<test>
  <sql>WITH HierarchicalEmps AS (
	SELECT	*,
			0 AS Level,
			e.EmployeeID.ToString() AS Path
	FROM	Employees e
	WHERE	e.ReportsTo IS NULL
	UNION	ALL
	SELECT	*,
			0 AS Level,
			e.EmployeeID.ToString() AS Path
	FROM	Employees e
	WHERE	e.ReportsTo IS NULL
	UNION	ALL
	SELECT	e.*,
			he.Level + 1 AS Level,
			he.Path + '.' + e.EmployeeID.ToString() AS Path
	FROM	Employees e
				INNER JOIN HierarchicalEmps he ON he.EmployeeId = e.ReportsTo 
	UNION	ALL
	SELECT	e.*,
			he.Level + 1 AS Level,
			he.Path + '.' + e.EmployeeID.ToString() AS Path
	FROM	Employees e
				INNER JOIN HierarchicalEmps he ON he.EmployeeId = e.ReportsTo 
)
SELECT	SPACE(he.Level * 8) + he.Firstname + ' ' + he.LastName AS Employee
FROM	HierarchicalEmps he
ORDER	BY he.Path</sql>
  <expectedResults>
    <NewDataSet>
  <xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="Table1">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="Employee" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <Table1>
    <Employee>Andrew Fuller</Employee>
  </Table1>
  <Table1>
    <Employee>Andrew Fuller</Employee>
  </Table1>
  <Table1>
    <Employee>        Nancy Davolio</Employee>
  </Table1>
  <Table1>
    <Employee>        Nancy Davolio</Employee>
  </Table1>
  <Table1>
    <Employee>        Nancy Davolio</Employee>
  </Table1>
  <Table1>
    <Employee>        Nancy Davolio</Employee>
  </Table1>
  <Table1>
    <Employee>        Janet Leverling</Employee>
  </Table1>
  <Table1>
    <Employee>        Janet Leverling</Employee>
  </Table1>
  <Table1>
    <Employee>        Janet Leverling</Employee>
  </Table1>
  <Table1>
    <Employee>        Janet Leverling</Employee>
  </Table1>
  <Table1>
    <Employee>        Margaret Peacock</Employee>
  </Table1>
  <Table1>
    <Employee>        Margaret Peacock</Employee>
  </Table1>
  <Table1>
    <Employee>        Margaret Peacock</Employee>
  </Table1>
  <Table1>
    <Employee>        Margaret Peacock</Employee>
  </Table1>
  <Table1>
    <Employee>        Steven Buchanan</Employee>
  </Table1>
  <Table1>
    <Employee>        Steven Buchanan</Employee>
  </Table1>
  <Table1>
    <Employee>        Steven Buchanan</Employee>
  </Table1>
  <Table1>
    <Employee>        Steven Buchanan</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Michael Suyama</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Robert King</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>                Anne Dodsworth</Employee>
  </Table1>
  <Table1>
    <Employee>        Laura Callahan</Employee>
  </Table1>
  <Table1>
    <Employee>        Laura Callahan</Employee>
  </Table1>
  <Table1>
    <Employee>        Laura Callahan</Employee>
  </Table1>
  <Table1>
    <Employee>        Laura Callahan</Employee>
  </Table1>
</NewDataSet>
  </expectedResults>
  <expectedPlan>
    <executionPlan>
      <element operator="Select">
        <properties>
          <property name="Output List.[0]" value="Expr1164 AS Employee" />
          <property name="Output List.[0].Column" value="Expr1164" />
          <property name="Output List.[0].DataType" value="String" />
          <property name="Output List.[0].Output Name" value="Employee" />
        </properties>
        <input>
          <element operator="Sort">
            <properties>
              <property name="Output List.[0]" value="Expr1164" />
              <property name="Output List.[0].Column" value="Expr1164" />
              <property name="Output List.[0].DataType" value="String" />
              <property name="Statistics.Open Count" value="1" />
              <property name="Statistics.Row Count" value="46" />
              <property name="Statistics.Average Row Count" value="46" />
              <property name="Logical Operator" value="Sort" />
              <property name="Order By.[0]" value="Union1163 ASC" />
              <property name="Order By.[0].Column" value="Union1163" />
              <property name="Order By.[0].DataType" value="String" />
              <property name="Order By.[0].Order" value="ASC" />
            </properties>
            <input>
              <element operator="ComputeScalar">
                <properties>
                  <property name="Output List.[0]" value="Union1163" />
                  <property name="Output List.[0].Column" value="Union1163" />
                  <property name="Output List.[0].DataType" value="String" />
                  <property name="Output List.[1]" value="Expr1164" />
                  <property name="Output List.[1].Column" value="Expr1164" />
                  <property name="Output List.[1].DataType" value="String" />
                  <property name="Statistics.Open Count" value="1" />
                  <property name="Statistics.Row Count" value="46" />
                  <property name="Statistics.Average Row Count" value="46" />
                  <property name="Defined Values.[0]" value="Expr1164 = SPACE(Union1162 * 8) + Union1146 + ' ' + Union1145" />
                  <property name="Defined Values.[0].Target" value="Expr1164" />
                  <property name="Defined Values.[0].DataType" value="String" />
                  <property name="Defined Values.[0].Source" value="SPACE(Union1162 * 8) + Union1146 + ' ' + Union1145" />
                </properties>
                <input>
                  <element operator="IndexSpool">
                    <properties>
                      <property name="Output List.[0]" value="Union1145" />
                      <property name="Output List.[0].Column" value="Union1145" />
                      <property name="Output List.[0].DataType" value="String" />
                      <property name="Output List.[1]" value="Union1146" />
                      <property name="Output List.[1].Column" value="Union1146" />
                      <property name="Output List.[1].DataType" value="String" />
                      <property name="Output List.[2]" value="Union1162" />
                      <property name="Output List.[2].Column" value="Union1162" />
                      <property name="Output List.[2].DataType" value="Int32" />
                      <property name="Output List.[3]" value="Union1163" />
                      <property name="Output List.[3].Column" value="Union1163" />
                      <property name="Output List.[3].DataType" value="String" />
                      <property name="Statistics.Open Count" value="1" />
                      <property name="Statistics.Row Count" value="46" />
                      <property name="Statistics.Average Row Count" value="46" />
                      <property name="Logical Operator" value="Lazy Spool" />
                      <property name="With Stack" value="True" />
                    </properties>
                    <input>
                      <element operator="Concatenation">
                        <properties>
                          <property name="Output List.[00]" value="Union1143" />
                          <property name="Output List.[00].Column" value="Union1143" />
                          <property name="Output List.[00].DataType" value="Int32" />
                          <property name="Output List.[01]" value="Union1144" />
                          <property name="Output List.[01].Column" value="Union1144" />
                          <property name="Output List.[01].DataType" value="Int32" />
                          <property name="Output List.[02]" value="Union1145" />
                          <property name="Output List.[02].Column" value="Union1145" />
                          <property name="Output List.[02].DataType" value="String" />
                          <property name="Output List.[03]" value="Union1146" />
                          <property name="Output List.[03].Column" value="Union1146" />
                          <property name="Output List.[03].DataType" value="String" />
                          <property name="Output List.[04]" value="Union1147" />
                          <property name="Output List.[04].Column" value="Union1147" />
                          <property name="Output List.[04].DataType" value="String" />
                          <property name="Output List.[05]" value="Union1148" />
                          <property name="Output List.[05].Column" value="Union1148" />
                          <property name="Output List.[05].DataType" value="String" />
                          <property name="Output List.[06]" value="Union1149" />
                          <property name="Output List.[06].Column" value="Union1149" />
                          <property name="Output List.[06].DataType" value="DateTime" />
                          <property name="Output List.[07]" value="Union1150" />
                          <property name="Output List.[07].Column" value="Union1150" />
                          <property name="Output List.[07].DataType" value="DateTime" />
                          <property name="Output List.[08]" value="Union1151" />
                          <property name="Output List.[08].Column" value="Union1151" />
                          <property name="Output List.[08].DataType" value="String" />
                          <property name="Output List.[09]" value="Union1152" />
                          <property name="Output List.[09].Column" value="Union1152" />
                          <property name="Output List.[09].DataType" value="String" />
                          <property name="Output List.[10]" value="Union1153" />
                          <property name="Output List.[10].Column" value="Union1153" />
                          <property name="Output List.[10].DataType" value="String" />
                          <property name="Output List.[11]" value="Union1154" />
                          <property name="Output List.[11].Column" value="Union1154" />
                          <property name="Output List.[11].DataType" value="String" />
                          <property name="Output List.[12]" value="Union1155" />
                          <property name="Output List.[12].Column" value="Union1155" />
                          <property name="Output List.[12].DataType" value="String" />
                          <property name="Output List.[13]" value="Union1156" />
                          <property name="Output List.[13].Column" value="Union1156" />
                          <property name="Output List.[13].DataType" value="String" />
                          <property name="Output List.[14]" value="Union1157" />
                          <property name="Output List.[14].Column" value="Union1157" />
                          <property name="Output List.[14].DataType" value="String" />
                          <property name="Output List.[15]" value="Union1158" />
                          <property name="Output List.[15].Column" value="Union1158" />
                          <property name="Output List.[15].DataType" value="Byte[]" />
                          <property name="Output List.[16]" value="Union1159" />
                          <property name="Output List.[16].Column" value="Union1159" />
                          <property name="Output List.[16].DataType" value="String" />
                          <property name="Output List.[17]" value="Union1160" />
                          <property name="Output List.[17].Column" value="Union1160" />
                          <property name="Output List.[17].DataType" value="Int32" />
                          <property name="Output List.[18]" value="Union1161" />
                          <property name="Output List.[18].Column" value="Union1161" />
                          <property name="Output List.[18].DataType" value="String" />
                          <property name="Output List.[19]" value="Union1162" />
                          <property name="Output List.[19].Column" value="Union1162" />
                          <property name="Output List.[19].DataType" value="Int32" />
                          <property name="Output List.[20]" value="Union1163" />
                          <property name="Output List.[20].Column" value="Union1163" />
                          <property name="Output List.[20].DataType" value="String" />
                          <property name="Statistics.Open Count" value="1" />
                          <property name="Statistics.Row Count" value="46" />
                          <property name="Statistics.Average Row Count" value="46" />
                          <property name="Defined Values.Union1143" value="Expr1060; Expr1082" />
                          <property name="Defined Values.Union1143.[0]" value="Expr1060" />
                          <property name="Defined Values.Union1143.[0].Column" value="Expr1060" />
                          <property name="Defined Values.Union1143.[0].DataType" value="Int32" />
                          <property name="Defined Values.Union1143.[1]" value="Expr1082" />
                          <property name="Defined Values.Union1143.[1].Column" value="Expr1082" />
                          <property name="Defined Values.Union1143.[1].DataType" value="Int32" />
                          <property name="Defined Values.Union1144" value="Union1040; Union1123" />
                          <property name="Defined Values.Union1144.[0]" value="Union1040" />
                          <property name="Defined Values.Union1144.[0].Column" value="Union1040" />
                          <property name="Defined Values.Union1144.[0].DataType" value="Int32" />
                          <property name="Defined Values.Union1144.[1]" value="Union1123" />
                          <property name="Defined Values.Union1144.[1].Column" value="Union1123" />
                          <property name="Defined Values.Union1144.[1].DataType" value="Int32" />
                          <property name="Defined Values.Union1145" value="Union1041; Union1124" />
                          <property name="Defined Values.Union1145.[0]" value="Union1041" />
                          <property name="Defined Values.Union1145.[0].Column" value="Union1041" />
                          <property name="Defined Values.Union1145.[0].DataType" value="String" />
                          <property name="Defined Values.Union1145.[1]" value="Union1124" />
                          <property name="Defined Values.Union1145.[1].Column" value="Union1124" />
                          <property name="Defined Values.Union1145.[1].DataType" value="String" />
                          <property name="Defined Values.Union1146" value="Union1042; Union1125" />
                          <property name="Defined Values.Union1146.[0]" value="Union1042" />
                          <property name="Defined Values.Union1146.[0].Column" value="Union1042" />
                          <property name="Defined Values.Union1146.[0].DataType" value="String" />
                          <property name="Defined Values.Union1146.[1]" value="Union1125" />
                          <property name="Defined Values.Union1146.[1].Column" value="Union1125" />
                          <property name="Defined Values.Union1146.[1].DataType" value="String" />
                          <property name="Defined Values.Union1147" value="Union1043; Union1126" />
                          <property name="Defined Values.Union1147.[0]" value="Union1043" />
                          <property name="Defined Values.Union1147.[0].Column" value="Union1043" />
                          <property name="Defined Values.Union1147.[0].DataType" value="String" />
                          <property name="Defined Values.Union1147.[1]" value="Union1126" />
                          <property name="Defined Values.Union1147.[1].Column" value="Union1126" />
                          <property name="Defined Values.Union1147.[1].DataType" value="String" />
                          <property name="Defined Values.Union1148" value="Union1044; Union1127" />
                          <property name="Defined Values.Union1148.[0]" value="Union1044" />
                          <property name="Defined Values.Union1148.[0].Column" value="Union1044" />
                          <property name="Defined Values.Union1148.[0].DataType" value="String" />
                          <property name="Defined Values.Union1148.[1]" value="Union1127" />
                          <property name="Defined Values.Union1148.[1].Column" value="Union1127" />
                          <property name="Defined Values.Union1148.[1].DataType" value="String" />
                          <property name="Defined Values.Union1149" value="Union1045; Union1128" />
                          <property name="Defined Values.Union1149.[0]" value="Union1045" />
                          <property name="Defined Values.Union1149.[0].Column" value="Union1045" />
                          <property name="Defined Values.Union1149.[0].DataType" value="DateTime" />
                          <property name="Defined Values.Union1149.[1]" value="Union1128" />
                          <property name="Defined Values.Union1149.[1].Column" value="Union1128" />
                          <property name="Defined Values.Union1149.[1].DataType" value="DateTime" />
                          <property name="Defined Values.Union1150" value="Union1046; Union1129" />
                          <property name="Defined Values.Union1150.[0]" value="Union1046" />
                          <property name="Defined Values.Union1150.[0].Column" value="Union1046" />
                          <property name="Defined Values.Union1150.[0].DataType" value="DateTime" />
                          <property name="Defined Values.Union1150.[1]" value="Union1129" />
                          <property name="Defined Values.Union1150.[1].Column" value="Union1129" />
                          <property name="Defined Values.Union1150.[1].DataType" value="DateTime" />
                          <property name="Defined Values.Union1151" value="Union1047; Union1130" />
                          <property name="Defined Values.Union1151.[0]" value="Union1047" />
                          <property name="Defined Values.Union1151.[0].Column" value="Union1047" />
                          <property name="Defined Values.Union1151.[0].DataType" value="String" />
                          <property name="Defined Values.Union1151.[1]" value="Union1130" />
                          <property name="Defined Values.Union1151.[1].Column" value="Union1130" />
                          <property name="Defined Values.Union1151.[1].DataType" value="String" />
                          <property name="Defined Values.Union1152" value="Union1048; Union1131" />
                          <property name="Defined Values.Union1152.[0]" value="Union1048" />
                          <property name="Defined Values.Union1152.[0].Column" value="Union1048" />
                          <property name="Defined Values.Union1152.[0].DataType" value="String" />
                          <property name="Defined Values.Union1152.[1]" value="Union1131" />
                          <property name="Defined Values.Union1152.[1].Column" value="Union1131" />
                          <property name="Defined Values.Union1152.[1].DataType" value="String" />
                          <property name="Defined Values.Union1153" value="Union1049; Union1132" />
                          <property name="Defined Values.Union1153.[0]" value="Union1049" />
                          <property name="Defined Values.Union1153.[0].Column" value="Union1049" />
                          <property name="Defined Values.Union1153.[0].DataType" value="String" />
                          <property name="Defined Values.Union1153.[1]" value="Union1132" />
                          <property name="Defined Values.Union1153.[1].Column" value="Union1132" />
                          <property name="Defined Values.Union1153.[1].DataType" value="String" />
                          <property name="Defined Values.Union1154" value="Union1050; Union1133" />
                          <property name="Defined Values.Union1154.[0]" value="Union1050" />
                          <property name="Defined Values.Union1154.[0].Column" value="Union1050" />
                          <property name="Defined Values.Union1154.[0].DataType" value="String" />
                          <property name="Defined Values.Union1154.[1]" value="Union1133" />
                          <property name="Defined Values.Union1154.[1].Column" value="Union1133" />
                          <property name="Defined Values.Union1154.[1].DataType" value="String" />
                          <property name="Defined Values.Union1155" value="Union1051; Union1134" />
                          <property name="Defined Values.Union1155.[0]" value="Union1051" />
                          <property name="Defined Values.Union1155.[0].Column" value="Union1051" />
                          <property name="Defined Values.Union1155.[0].DataType" value="String" />
                          <property name="Defined Values.Union1155.[1]" value="Union1134" />
                          <property name="Defined Values.Union1155.[1].Column" value="Union1134" />
                          <property name="Defined Values.Union1155.[1].DataType" value="String" />
                          <property name="Defined Values.Union1156" value="Union1052; Union1135" />
                          <property name="Defined Values.Union1156.[0]" value="Union1052" />
                          <property name="Defined Values.Union1156.[0].Column" value="Union1052" />
                          <property name="Defined Values.Union1156.[0].DataType" value="String" />
                          <property name="Defined Values.Union1156.[1]" value="Union1135" />
                          <property name="Defined Values.Union1156.[1].Column" value="Union1135" />
                          <property name="Defined Values.Union1156.[1].DataType" value="String" />
                          <property name="Defined Values.Union1157" value="Union1053; Union1136" />
                          <property name="Defined Values.Union1157.[0]" value="Union1053" />
                          <property name="Defined Values.Union1157.[0].Column" value="Union1053" />
                          <property name="Defined Values.Union1157.[0].DataType" value="String" />
                          <property name="Defined Values.Union1157.[1]" value="Union1136" />
                          <property name="Defined Values.Union1157.[1].Column" value="Union1136" />
                          <property name="Defined Values.Union1157.[1].DataType" value="String" />
                          <property name="Defined Values.Union1158" value="Union1054; Union1137" />
                          <property name="Defined Values.Union1158.[0]" value="Union1054" />
                          <property name="Defined Values.Union1158.[0].Column" value="Union1054" />
                          <property name="Defined Values.Union1158.[0].DataType" value="Byte[]" />
                          <property name="Defined Values.Union1158.[1]" value="Union1137" />
                          <property name="Defined Values.Union1158.[1].Column" value="Union1137" />
                          <property name="Defined Values.Union1158.[1].DataType" value="Byte[]" />
                          <property name="Defined Values.Union1159" value="Union1055; Union1138" />
                          <property name="Defined Values.Union1159.[0]" value="Union1055" />
                          <property name="Defined Values.Union1159.[0].Column" value="Union1055" />
                          <property name="Defined Values.Union1159.[0].DataType" value="String" />
                          <property name="Defined Values.Union1159.[1]" value="Union1138" />
                          <property name="Defined Values.Union1159.[1].Column" value="Union1138" />
                          <property name="Defined Values.Union1159.[1].DataType" value="String" />
                          <property name="Defined Values.Union1160" value="Union1056; Union1139" />
                          <property name="Defined Values.Union1160.[0]" value="Union1056" />
                          <property name="Defined Values.Union1160.[0].Column" value="Union1056" />
                          <property name="Defined Values.Union1160.[0].DataType" value="Int32" />
                          <property name="Defined Values.Union1160.[1]" value="Union1139" />
                          <property name="Defined Values.Union1160.[1].Column" value="Union1139" />
                          <property name="Defined Values.Union1160.[1].DataType" value="Int32" />
                          <property name="Defined Values.Union1161" value="Union1057; Union1140" />
                          <property name="Defined Values.Union1161.[0]" value="Union1057" />
                          <property name="Defined Values.Union1161.[0].Column" value="Union1057" />
                          <property name="Defined Values.Union1161.[0].DataType" value="String" />
                          <property name="Defined Values.Union1161.[1]" value="Union1140" />
                          <property name="Defined Values.Union1161.[1].Column" value="Union1140" />
                          <property name="Defined Values.Union1161.[1].DataType" value="String" />
                          <property name="Defined Values.Union1162" value="Union1058; Union1141" />
                          <property name="Defined Values.Union1162.[0]" value="Union1058" />
                          <property name="Defined Values.Union1162.[0].Column" value="Union1058" />
                          <property name="Defined Values.Union1162.[0].DataType" value="Int32" />
                          <property name="Defined Values.Union1162.[1]" value="Union1141" />
                          <property name="Defined Values.Union1162.[1].Column" value="Union1141" />
                          <property name="Defined Values.Union1162.[1].DataType" value="Int32" />
                          <property name="Defined Values.Union1163" value="Union1059; Union1142" />
                          <property name="Defined Values.Union1163.[0]" value="Union1059" />
                          <property name="Defined Values.Union1163.[0].Column" value="Union1059" />
                          <property name="Defined Values.Union1163.[0].DataType" value="String" />
                          <property name="Defined Values.Union1163.[1]" value="Union1142" />
                          <property name="Defined Values.Union1163.[1].Column" value="Union1142" />
                          <property name="Defined Values.Union1163.[1].DataType" value="String" />
                        </properties>
                        <input>
                          <element operator="ComputeScalar">
                            <properties>
                              <property name="Output List.[00]" value="Union1040" />
                              <property name="Output List.[00].Column" value="Union1040" />
                              <property name="Output List.[00].DataType" value="Int32" />
                              <property name="Output List.[01]" value="Union1041" />
                              <property name="Output List.[01].Column" value="Union1041" />
                              <property name="Output List.[01].DataType" value="String" />
                              <property name="Output List.[02]" value="Union1042" />
                              <property name="Output List.[02].Column" value="Union1042" />
                              <property name="Output List.[02].DataType" value="String" />
                              <property name="Output List.[03]" value="Union1043" />
                              <property name="Output List.[03].Column" value="Union1043" />
                              <property name="Output List.[03].DataType" value="String" />
                              <property name="Output List.[04]" value="Union1044" />
                              <property name="Output List.[04].Column" value="Union1044" />
                              <property name="Output List.[04].DataType" value="String" />
                              <property name="Output List.[05]" value="Union1045" />
                              <property name="Output List.[05].Column" value="Union1045" />
                              <property name="Output List.[05].DataType" value="DateTime" />
                              <property name="Output List.[06]" value="Union1046" />
                              <property name="Output List.[06].Column" value="Union1046" />
                              <property name="Output List.[06].DataType" value="DateTime" />
                              <property name="Output List.[07]" value="Union1047" />
                              <property name="Output List.[07].Column" value="Union1047" />
                              <property name="Output List.[07].DataType" value="String" />
                              <property name="Output List.[08]" value="Union1048" />
                              <property name="Output List.[08].Column" value="Union1048" />
                              <property name="Output List.[08].DataType" value="String" />
                              <property name="Output List.[09]" value="Union1049" />
                              <property name="Output List.[09].Column" value="Union1049" />
                              <property name="Output List.[09].DataType" value="String" />
                              <property name="Output List.[10]" value="Union1050" />
                              <property name="Output List.[10].Column" value="Union1050" />
                              <property name="Output List.[10].DataType" value="String" />
                              <property name="Output List.[11]" value="Union1051" />
                              <property name="Output List.[11].Column" value="Union1051" />
                              <property name="Output List.[11].DataType" value="String" />
                              <property name="Output List.[12]" value="Union1052" />
                              <property name="Output List.[12].Column" value="Union1052" />
                              <property name="Output List.[12].DataType" value="String" />
                              <property name="Output List.[13]" value="Union1053" />
                              <property name="Output List.[13].Column" value="Union1053" />
                              <property name="Output List.[13].DataType" value="String" />
                              <property name="Output List.[14]" value="Union1054" />
                              <property name="Output List.[14].Column" value="Union1054" />
                              <property name="Output List.[14].DataType" value="Byte[]" />
                              <property name="Output List.[15]" value="Union1055" />
                              <property name="Output List.[15].Column" value="Union1055" />
                              <property name="Output List.[15].DataType" value="String" />
                              <property name="Output List.[16]" value="Union1056" />
                              <property name="Output List.[16].Column" value="Union1056" />
                              <property name="Output List.[16].DataType" value="Int32" />
                              <property name="Output List.[17]" value="Union1057" />
                              <property name="Output List.[17].Column" value="Union1057" />
                              <property name="Output List.[17].DataType" value="String" />
                              <property name="Output List.[18]" value="Union1058" />
                              <property name="Output List.[18].Column" value="Union1058" />
                              <property name="Output List.[18].DataType" value="Int32" />
                              <property name="Output List.[19]" value="Union1059" />
                              <property name="Output List.[19].Column" value="Union1059" />
                              <property name="Output List.[19].DataType" value="String" />
                              <property name="Output List.[20]" value="Expr1060" />
                              <property name="Output List.[20].Column" value="Expr1060" />
                              <property name="Output List.[20].DataType" value="Int32" />
                              <property name="Statistics.Open Count" value="1" />
                              <property name="Statistics.Row Count" value="2" />
                              <property name="Statistics.Average Row Count" value="2" />
                              <property name="Defined Values.[0]" value="Expr1060 = 0" />
                              <property name="Defined Values.[0].Target" value="Expr1060" />
                              <property name="Defined Values.[0].DataType" value="Int32" />
                              <property name="Defined Values.[0].Source" value="0" />
                            </properties>
                            <input>
                              <element operator="Concatenation">
                                <properties>
                                  <property name="Output List.[00]" value="Union1040" />
                                  <property name="Output List.[00].Column" value="Union1040" />
                                  <property name="Output List.[00].DataType" value="Int32" />
                                  <property name="Output List.[01]" value="Union1041" />
                                  <property name="Output List.[01].Column" value="Union1041" />
                                  <property name="Output List.[01].DataType" value="String" />
                                  <property name="Output List.[02]" value="Union1042" />
                                  <property name="Output List.[02].Column" value="Union1042" />
                                  <property name="Output List.[02].DataType" value="String" />
                                  <property name="Output List.[03]" value="Union1043" />
                                  <property name="Output List.[03].Column" value="Union1043" />
                                  <property name="Output List.[03].DataType" value="String" />
                                  <property name="Output List.[04]" value="Union1044" />
                                  <property name="Output List.[04].Column" value="Union1044" />
                                  <property name="Output List.[04].DataType" value="String" />
                                  <property name="Output List.[05]" value="Union1045" />
                                  <property name="Output List.[05].Column" value="Union1045" />
                                  <property name="Output List.[05].DataType" value="DateTime" />
                                  <property name="Output List.[06]" value="Union1046" />
                                  <property name="Output List.[06].Column" value="Union1046" />
                                  <property name="Output List.[06].DataType" value="DateTime" />
                                  <property name="Output List.[07]" value="Union1047" />
                                  <property name="Output List.[07].Column" value="Union1047" />
                                  <property name="Output List.[07].DataType" value="String" />
                                  <property name="Output List.[08]" value="Union1048" />
                                  <property name="Output List.[08].Column" value="Union1048" />
                                  <property name="Output List.[08].DataType" value="String" />
                                  <property name="Output List.[09]" value="Union1049" />
                                  <property name="Output List.[09].Column" value="Union1049" />
                                  <property name="Output List.[09].DataType" value="String" />
                                  <property name="Output List.[10]" value="Union1050" />
                                  <property name="Output List.[10].Column" value="Union1050" />
                                  <property name="Output List.[10].DataType" value="String" />
                                  <property name="Output List.[11]" value="Union1051" />
                                  <property name="Output List.[11].Column" value="Union1051" />
                                  <property name="Output List.[11].DataType" value="String" />
                                  <property name="Output List.[12]" value="Union1052" />
                                  <property name="Output List.[12].Column" value="Union1052" />
                                  <property name="Output List.[12].DataType" value="String" />
                                  <property name="Output List.[13]" value="Union1053" />
                                  <property name="Output List.[13].Column" value="Union1053" />
                                  <property name="Output List.[13].DataType" value="String" />
                                  <property name="Output List.[14]" value="Union1054" />
                                  <property name="Output List.[14].Column" value="Union1054" />
                                  <property name="Output List.[14].DataType" value="Byte[]" />
                                  <property name="Output List.[15]" value="Union1055" />
                                  <property name="Output List.[15].Column" value="Union1055" />
                                  <property name="Output List.[15].DataType" value="String" />
                                  <property name="Output List.[16]" value="Union1056" />
                                  <property name="Output List.[16].Column" value="Union1056" />
                                  <property name="Output List.[16].DataType" value="Int32" />
                                  <property name="Output List.[17]" value="Union1057" />
                                  <property name="Output List.[17].Column" value="Union1057" />
                                  <property name="Output List.[17].DataType" value="String" />
                                  <property name="Output List.[18]" value="Union1058" />
                                  <property name="Output List.[18].Column" value="Union1058" />
                                  <property name="Output List.[18].DataType" value="Int32" />
                                  <property name="Output List.[19]" value="Union1059" />
                                  <property name="Output List.[19].Column" value="Union1059" />
                                  <property name="Output List.[19].DataType" value="String" />
                                  <property name="Statistics.Open Count" value="1" />
                                  <property name="Statistics.Row Count" value="2" />
                                  <property name="Statistics.Average Row Count" value="2" />
                                  <property name="Defined Values.Union1040" value="e.EmployeeID; e.EmployeeID" />
                                  <property name="Defined Values.Union1040.[0]" value="e.EmployeeID" />
                                  <property name="Defined Values.Union1040.[0].Table" value="e" />
                                  <property name="Defined Values.Union1040.[0].Column" value="EmployeeID" />
                                  <property name="Defined Values.Union1040.[0].DataType" value="Int32" />
                                  <property name="Defined Values.Union1040.[1]" value="e.EmployeeID" />
                                  <property name="Defined Values.Union1040.[1].Table" value="e" />
                                  <property name="Defined Values.Union1040.[1].Column" value="EmployeeID" />
                                  <property name="Defined Values.Union1040.[1].DataType" value="Int32" />
                                  <property name="Defined Values.Union1041" value="e.LastName; e.LastName" />
                                  <property name="Defined Values.Union1041.[0]" value="e.LastName" />
                                  <property name="Defined Values.Union1041.[0].Table" value="e" />
                                  <property name="Defined Values.Union1041.[0].Column" value="LastName" />
                                  <property name="Defined Values.Union1041.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1041.[1]" value="e.LastName" />
                                  <property name="Defined Values.Union1041.[1].Table" value="e" />
                                  <property name="Defined Values.Union1041.[1].Column" value="LastName" />
                                  <property name="Defined Values.Union1041.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1042" value="e.FirstName; e.FirstName" />
                                  <property name="Defined Values.Union1042.[0]" value="e.FirstName" />
                                  <property name="Defined Values.Union1042.[0].Table" value="e" />
                                  <property name="Defined Values.Union1042.[0].Column" value="FirstName" />
                                  <property name="Defined Values.Union1042.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1042.[1]" value="e.FirstName" />
                                  <property name="Defined Values.Union1042.[1].Table" value="e" />
                                  <property name="Defined Values.Union1042.[1].Column" value="FirstName" />
                                  <property name="Defined Values.Union1042.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1043" value="e.Title; e.Title" />
                                  <property name="Defined Values.Union1043.[0]" value="e.Title" />
                                  <property name="Defined Values.Union1043.[0].Table" value="e" />
                                  <property name="Defined Values.Union1043.[0].Column" value="Title" />
                                  <property name="Defined Values.Union1043.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1043.[1]" value="e.Title" />
                                  <property name="Defined Values.Union1043.[1].Table" value="e" />
                                  <property name="Defined Values.Union1043.[1].Column" value="Title" />
                                  <property name="Defined Values.Union1043.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1044" value="e.TitleOfCourtesy; e.TitleOfCourtesy" />
                                  <property name="Defined Values.Union1044.[0]" value="e.TitleOfCourtesy" />
                                  <property name="Defined Values.Union1044.[0].Table" value="e" />
                                  <property name="Defined Values.Union1044.[0].Column" value="TitleOfCourtesy" />
                                  <property name="Defined Values.Union1044.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1044.[1]" value="e.TitleOfCourtesy" />
                                  <property name="Defined Values.Union1044.[1].Table" value="e" />
                                  <property name="Defined Values.Union1044.[1].Column" value="TitleOfCourtesy" />
                                  <property name="Defined Values.Union1044.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1045" value="e.BirthDate; e.BirthDate" />
                                  <property name="Defined Values.Union1045.[0]" value="e.BirthDate" />
                                  <property name="Defined Values.Union1045.[0].Table" value="e" />
                                  <property name="Defined Values.Union1045.[0].Column" value="BirthDate" />
                                  <property name="Defined Values.Union1045.[0].DataType" value="DateTime" />
                                  <property name="Defined Values.Union1045.[1]" value="e.BirthDate" />
                                  <property name="Defined Values.Union1045.[1].Table" value="e" />
                                  <property name="Defined Values.Union1045.[1].Column" value="BirthDate" />
                                  <property name="Defined Values.Union1045.[1].DataType" value="DateTime" />
                                  <property name="Defined Values.Union1046" value="e.HireDate; e.HireDate" />
                                  <property name="Defined Values.Union1046.[0]" value="e.HireDate" />
                                  <property name="Defined Values.Union1046.[0].Table" value="e" />
                                  <property name="Defined Values.Union1046.[0].Column" value="HireDate" />
                                  <property name="Defined Values.Union1046.[0].DataType" value="DateTime" />
                                  <property name="Defined Values.Union1046.[1]" value="e.HireDate" />
                                  <property name="Defined Values.Union1046.[1].Table" value="e" />
                                  <property name="Defined Values.Union1046.[1].Column" value="HireDate" />
                                  <property name="Defined Values.Union1046.[1].DataType" value="DateTime" />
                                  <property name="Defined Values.Union1047" value="e.Address; e.Address" />
                                  <property name="Defined Values.Union1047.[0]" value="e.Address" />
                                  <property name="Defined Values.Union1047.[0].Table" value="e" />
                                  <property name="Defined Values.Union1047.[0].Column" value="Address" />
                                  <property name="Defined Values.Union1047.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1047.[1]" value="e.Address" />
                                  <property name="Defined Values.Union1047.[1].Table" value="e" />
                                  <property name="Defined Values.Union1047.[1].Column" value="Address" />
                                  <property name="Defined Values.Union1047.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1048" value="e.City; e.City" />
                                  <property name="Defined Values.Union1048.[0]" value="e.City" />
                                  <property name="Defined Values.Union1048.[0].Table" value="e" />
                                  <property name="Defined Values.Union1048.[0].Column" value="City" />
                                  <property name="Defined Values.Union1048.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1048.[1]" value="e.City" />
                                  <property name="Defined Values.Union1048.[1].Table" value="e" />
                                  <property name="Defined Values.Union1048.[1].Column" value="City" />
                                  <property name="Defined Values.Union1048.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1049" value="e.Region; e.Region" />
                                  <property name="Defined Values.Union1049.[0]" value="e.Region" />
                                  <property name="Defined Values.Union1049.[0].Table" value="e" />
                                  <property name="Defined Values.Union1049.[0].Column" value="Region" />
                                  <property name="Defined Values.Union1049.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1049.[1]" value="e.Region" />
                                  <property name="Defined Values.Union1049.[1].Table" value="e" />
                                  <property name="Defined Values.Union1049.[1].Column" value="Region" />
                                  <property name="Defined Values.Union1049.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1050" value="e.PostalCode; e.PostalCode" />
                                  <property name="Defined Values.Union1050.[0]" value="e.PostalCode" />
                                  <property name="Defined Values.Union1050.[0].Table" value="e" />
                                  <property name="Defined Values.Union1050.[0].Column" value="PostalCode" />
                                  <property name="Defined Values.Union1050.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1050.[1]" value="e.PostalCode" />
                                  <property name="Defined Values.Union1050.[1].Table" value="e" />
                                  <property name="Defined Values.Union1050.[1].Column" value="PostalCode" />
                                  <property name="Defined Values.Union1050.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1051" value="e.Country; e.Country" />
                                  <property name="Defined Values.Union1051.[0]" value="e.Country" />
                                  <property name="Defined Values.Union1051.[0].Table" value="e" />
                                  <property name="Defined Values.Union1051.[0].Column" value="Country" />
                                  <property name="Defined Values.Union1051.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1051.[1]" value="e.Country" />
                                  <property name="Defined Values.Union1051.[1].Table" value="e" />
                                  <property name="Defined Values.Union1051.[1].Column" value="Country" />
                                  <property name="Defined Values.Union1051.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1052" value="e.HomePhone; e.HomePhone" />
                                  <property name="Defined Values.Union1052.[0]" value="e.HomePhone" />
                                  <property name="Defined Values.Union1052.[0].Table" value="e" />
                                  <property name="Defined Values.Union1052.[0].Column" value="HomePhone" />
                                  <property name="Defined Values.Union1052.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1052.[1]" value="e.HomePhone" />
                                  <property name="Defined Values.Union1052.[1].Table" value="e" />
                                  <property name="Defined Values.Union1052.[1].Column" value="HomePhone" />
                                  <property name="Defined Values.Union1052.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1053" value="e.Extension; e.Extension" />
                                  <property name="Defined Values.Union1053.[0]" value="e.Extension" />
                                  <property name="Defined Values.Union1053.[0].Table" value="e" />
                                  <property name="Defined Values.Union1053.[0].Column" value="Extension" />
                                  <property name="Defined Values.Union1053.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1053.[1]" value="e.Extension" />
                                  <property name="Defined Values.Union1053.[1].Table" value="e" />
                                  <property name="Defined Values.Union1053.[1].Column" value="Extension" />
                                  <property name="Defined Values.Union1053.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1054" value="e.Photo; e.Photo" />
                                  <property name="Defined Values.Union1054.[0]" value="e.Photo" />
                                  <property name="Defined Values.Union1054.[0].Table" value="e" />
                                  <property name="Defined Values.Union1054.[0].Column" value="Photo" />
                                  <property name="Defined Values.Union1054.[0].DataType" value="Byte[]" />
                                  <property name="Defined Values.Union1054.[1]" value="e.Photo" />
                                  <property name="Defined Values.Union1054.[1].Table" value="e" />
                                  <property name="Defined Values.Union1054.[1].Column" value="Photo" />
                                  <property name="Defined Values.Union1054.[1].DataType" value="Byte[]" />
                                  <property name="Defined Values.Union1055" value="e.Notes; e.Notes" />
                                  <property name="Defined Values.Union1055.[0]" value="e.Notes" />
                                  <property name="Defined Values.Union1055.[0].Table" value="e" />
                                  <property name="Defined Values.Union1055.[0].Column" value="Notes" />
                                  <property name="Defined Values.Union1055.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1055.[1]" value="e.Notes" />
                                  <property name="Defined Values.Union1055.[1].Table" value="e" />
                                  <property name="Defined Values.Union1055.[1].Column" value="Notes" />
                                  <property name="Defined Values.Union1055.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1056" value="e.ReportsTo; e.ReportsTo" />
                                  <property name="Defined Values.Union1056.[0]" value="e.ReportsTo" />
                                  <property name="Defined Values.Union1056.[0].Table" value="e" />
                                  <property name="Defined Values.Union1056.[0].Column" value="ReportsTo" />
                                  <property name="Defined Values.Union1056.[0].DataType" value="Int32" />
                                  <property name="Defined Values.Union1056.[1]" value="e.ReportsTo" />
                                  <property name="Defined Values.Union1056.[1].Table" value="e" />
                                  <property name="Defined Values.Union1056.[1].Column" value="ReportsTo" />
                                  <property name="Defined Values.Union1056.[1].DataType" value="Int32" />
                                  <property name="Defined Values.Union1057" value="e.PhotoPath; e.PhotoPath" />
                                  <property name="Defined Values.Union1057.[0]" value="e.PhotoPath" />
                                  <property name="Defined Values.Union1057.[0].Table" value="e" />
                                  <property name="Defined Values.Union1057.[0].Column" value="PhotoPath" />
                                  <property name="Defined Values.Union1057.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1057.[1]" value="e.PhotoPath" />
                                  <property name="Defined Values.Union1057.[1].Table" value="e" />
                                  <property name="Defined Values.Union1057.[1].Column" value="PhotoPath" />
                                  <property name="Defined Values.Union1057.[1].DataType" value="String" />
                                  <property name="Defined Values.Union1058" value="Expr1018; Expr1038" />
                                  <property name="Defined Values.Union1058.[0]" value="Expr1018" />
                                  <property name="Defined Values.Union1058.[0].Column" value="Expr1018" />
                                  <property name="Defined Values.Union1058.[0].DataType" value="Int32" />
                                  <property name="Defined Values.Union1058.[1]" value="Expr1038" />
                                  <property name="Defined Values.Union1058.[1].Column" value="Expr1038" />
                                  <property name="Defined Values.Union1058.[1].DataType" value="Int32" />
                                  <property name="Defined Values.Union1059" value="Expr1019; Expr1039" />
                                  <property name="Defined Values.Union1059.[0]" value="Expr1019" />
                                  <property name="Defined Values.Union1059.[0].Column" value="Expr1019" />
                                  <property name="Defined Values.Union1059.[0].DataType" value="String" />
                                  <property name="Defined Values.Union1059.[1]" value="Expr1039" />
                                  <property name="Defined Values.Union1059.[1].Column" value="Expr1039" />
                                  <property name="Defined Values.Union1059.[1].DataType" value="String" />
                                </properties>
                                <input>
                                  <element operator="ComputeScalar">
                                    <properties>
                                      <property name="Output List.[00]" value="e.EmployeeID" />
                                      <property name="Output List.[00].Table" value="e" />
                                      <property name="Output List.[00].Column" value="EmployeeID" />
                                      <property name="Output List.[00].DataType" value="Int32" />
                                      <property name="Output List.[01]" value="e.LastName" />
                                      <property name="Output List.[01].Table" value="e" />
                                      <property name="Output List.[01].Column" value="LastName" />
                                      <property name="Output List.[01].DataType" value="String" />
                                      <property name="Output List.[02]" value="e.FirstName" />
                                      <property name="Output List.[02].Table" value="e" />
                                      <property name="Output List.[02].Column" value="FirstName" />
                                      <property name="Output List.[02].DataType" value="String" />
                                      <property name="Output List.[03]" value="e.Title" />
                                      <property name="Output List.[03].Table" value="e" />
                                      <property name="Output List.[03].Column" value="Title" />
                                      <property name="Output List.[03].DataType" value="String" />
                                      <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                      <property name="Output List.[04].Table" value="e" />
                                      <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                      <property name="Output List.[04].DataType" value="String" />
                                      <property name="Output List.[05]" value="e.BirthDate" />
                                      <property name="Output List.[05].Table" value="e" />
                                      <property name="Output List.[05].Column" value="BirthDate" />
                                      <property name="Output List.[05].DataType" value="DateTime" />
                                      <property name="Output List.[06]" value="e.HireDate" />
                                      <property name="Output List.[06].Table" value="e" />
                                      <property name="Output List.[06].Column" value="HireDate" />
                                      <property name="Output List.[06].DataType" value="DateTime" />
                                      <property name="Output List.[07]" value="e.Address" />
                                      <property name="Output List.[07].Table" value="e" />
                                      <property name="Output List.[07].Column" value="Address" />
                                      <property name="Output List.[07].DataType" value="String" />
                                      <property name="Output List.[08]" value="e.City" />
                                      <property name="Output List.[08].Table" value="e" />
                                      <property name="Output List.[08].Column" value="City" />
                                      <property name="Output List.[08].DataType" value="String" />
                                      <property name="Output List.[09]" value="e.Region" />
                                      <property name="Output List.[09].Table" value="e" />
                                      <property name="Output List.[09].Column" value="Region" />
                                      <property name="Output List.[09].DataType" value="String" />
                                      <property name="Output List.[10]" value="e.PostalCode" />
                                      <property name="Output List.[10].Table" value="e" />
                                      <property name="Output List.[10].Column" value="PostalCode" />
                                      <property name="Output List.[10].DataType" value="String" />
                                      <property name="Output List.[11]" value="e.Country" />
                                      <property name="Output List.[11].Table" value="e" />
                                      <property name="Output List.[11].Column" value="Country" />
                                      <property name="Output List.[11].DataType" value="String" />
                                      <property name="Output List.[12]" value="e.HomePhone" />
                                      <property name="Output List.[12].Table" value="e" />
                                      <property name="Output List.[12].Column" value="HomePhone" />
                                      <property name="Output List.[12].DataType" value="String" />
                                      <property name="Output List.[13]" value="e.Extension" />
                                      <property name="Output List.[13].Table" value="e" />
                                      <property name="Output List.[13].Column" value="Extension" />
                                      <property name="Output List.[13].DataType" value="String" />
                                      <property name="Output List.[14]" value="e.Photo" />
                                      <property name="Output List.[14].Table" value="e" />
                                      <property name="Output List.[14].Column" value="Photo" />
                                      <property name="Output List.[14].DataType" value="Byte[]" />
                                      <property name="Output List.[15]" value="e.Notes" />
                                      <property name="Output List.[15].Table" value="e" />
                                      <property name="Output List.[15].Column" value="Notes" />
                                      <property name="Output List.[15].DataType" value="String" />
                                      <property name="Output List.[16]" value="e.ReportsTo" />
                                      <property name="Output List.[16].Table" value="e" />
                                      <property name="Output List.[16].Column" value="ReportsTo" />
                                      <property name="Output List.[16].DataType" value="Int32" />
                                      <property name="Output List.[17]" value="e.PhotoPath" />
                                      <property name="Output List.[17].Table" value="e" />
                                      <property name="Output List.[17].Column" value="PhotoPath" />
                                      <property name="Output List.[17].DataType" value="String" />
                                      <property name="Output List.[18]" value="Expr1018" />
                                      <property name="Output List.[18].Column" value="Expr1018" />
                                      <property name="Output List.[18].DataType" value="Int32" />
                                      <property name="Output List.[19]" value="Expr1019" />
                                      <property name="Output List.[19].Column" value="Expr1019" />
                                      <property name="Output List.[19].DataType" value="String" />
                                      <property name="Statistics.Open Count" value="1" />
                                      <property name="Statistics.Row Count" value="1" />
                                      <property name="Statistics.Average Row Count" value="1" />
                                      <property name="Defined Values.[0]" value="Expr1018 = 0" />
                                      <property name="Defined Values.[0].Target" value="Expr1018" />
                                      <property name="Defined Values.[0].DataType" value="Int32" />
                                      <property name="Defined Values.[0].Source" value="0" />
                                      <property name="Defined Values.[1]" value="Expr1019 = e.EmployeeID.ToString()" />
                                      <property name="Defined Values.[1].Target" value="Expr1019" />
                                      <property name="Defined Values.[1].DataType" value="String" />
                                      <property name="Defined Values.[1].Source" value="e.EmployeeID.ToString()" />
                                    </properties>
                                    <input>
                                      <element operator="Filter">
                                        <properties>
                                          <property name="Output List.[00]" value="e.EmployeeID" />
                                          <property name="Output List.[00].Table" value="e" />
                                          <property name="Output List.[00].Column" value="EmployeeID" />
                                          <property name="Output List.[00].DataType" value="Int32" />
                                          <property name="Output List.[01]" value="e.LastName" />
                                          <property name="Output List.[01].Table" value="e" />
                                          <property name="Output List.[01].Column" value="LastName" />
                                          <property name="Output List.[01].DataType" value="String" />
                                          <property name="Output List.[02]" value="e.FirstName" />
                                          <property name="Output List.[02].Table" value="e" />
                                          <property name="Output List.[02].Column" value="FirstName" />
                                          <property name="Output List.[02].DataType" value="String" />
                                          <property name="Output List.[03]" value="e.Title" />
                                          <property name="Output List.[03].Table" value="e" />
                                          <property name="Output List.[03].Column" value="Title" />
                                          <property name="Output List.[03].DataType" value="String" />
                                          <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                          <property name="Output List.[04].Table" value="e" />
                                          <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                          <property name="Output List.[04].DataType" value="String" />
                                          <property name="Output List.[05]" value="e.BirthDate" />
                                          <property name="Output List.[05].Table" value="e" />
                                          <property name="Output List.[05].Column" value="BirthDate" />
                                          <property name="Output List.[05].DataType" value="DateTime" />
                                          <property name="Output List.[06]" value="e.HireDate" />
                                          <property name="Output List.[06].Table" value="e" />
                                          <property name="Output List.[06].Column" value="HireDate" />
                                          <property name="Output List.[06].DataType" value="DateTime" />
                                          <property name="Output List.[07]" value="e.Address" />
                                          <property name="Output List.[07].Table" value="e" />
                                          <property name="Output List.[07].Column" value="Address" />
                                          <property name="Output List.[07].DataType" value="String" />
                                          <property name="Output List.[08]" value="e.City" />
                                          <property name="Output List.[08].Table" value="e" />
                                          <property name="Output List.[08].Column" value="City" />
                                          <property name="Output List.[08].DataType" value="String" />
                                          <property name="Output List.[09]" value="e.Region" />
                                          <property name="Output List.[09].Table" value="e" />
                                          <property name="Output List.[09].Column" value="Region" />
                                          <property name="Output List.[09].DataType" value="String" />
                                          <property name="Output List.[10]" value="e.PostalCode" />
                                          <property name="Output List.[10].Table" value="e" />
                                          <property name="Output List.[10].Column" value="PostalCode" />
                                          <property name="Output List.[10].DataType" value="String" />
                                          <property name="Output List.[11]" value="e.Country" />
                                          <property name="Output List.[11].Table" value="e" />
                                          <property name="Output List.[11].Column" value="Country" />
                                          <property name="Output List.[11].DataType" value="String" />
                                          <property name="Output List.[12]" value="e.HomePhone" />
                                          <property name="Output List.[12].Table" value="e" />
                                          <property name="Output List.[12].Column" value="HomePhone" />
                                          <property name="Output List.[12].DataType" value="String" />
                                          <property name="Output List.[13]" value="e.Extension" />
                                          <property name="Output List.[13].Table" value="e" />
                                          <property name="Output List.[13].Column" value="Extension" />
                                          <property name="Output List.[13].DataType" value="String" />
                                          <property name="Output List.[14]" value="e.Photo" />
                                          <property name="Output List.[14].Table" value="e" />
                                          <property name="Output List.[14].Column" value="Photo" />
                                          <property name="Output List.[14].DataType" value="Byte[]" />
                                          <property name="Output List.[15]" value="e.Notes" />
                                          <property name="Output List.[15].Table" value="e" />
                                          <property name="Output List.[15].Column" value="Notes" />
                                          <property name="Output List.[15].DataType" value="String" />
                                          <property name="Output List.[16]" value="e.ReportsTo" />
                                          <property name="Output List.[16].Table" value="e" />
                                          <property name="Output List.[16].Column" value="ReportsTo" />
                                          <property name="Output List.[16].DataType" value="Int32" />
                                          <property name="Output List.[17]" value="e.PhotoPath" />
                                          <property name="Output List.[17].Table" value="e" />
                                          <property name="Output List.[17].Column" value="PhotoPath" />
                                          <property name="Output List.[17].DataType" value="String" />
                                          <property name="Statistics.Open Count" value="1" />
                                          <property name="Statistics.Row Count" value="1" />
                                          <property name="Statistics.Average Row Count" value="1" />
                                          <property name="Predicate" value="e.ReportsTo IS NULL" />
                                        </properties>
                                        <input>
                                          <element operator="TableScan">
                                            <properties>
                                              <property name="Table" value="Employees AS e" />
                                              <property name="Output List.[00]" value="e.EmployeeID" />
                                              <property name="Output List.[00].Table" value="e" />
                                              <property name="Output List.[00].Column" value="EmployeeID" />
                                              <property name="Output List.[00].DataType" value="Int32" />
                                              <property name="Output List.[01]" value="e.LastName" />
                                              <property name="Output List.[01].Table" value="e" />
                                              <property name="Output List.[01].Column" value="LastName" />
                                              <property name="Output List.[01].DataType" value="String" />
                                              <property name="Output List.[02]" value="e.FirstName" />
                                              <property name="Output List.[02].Table" value="e" />
                                              <property name="Output List.[02].Column" value="FirstName" />
                                              <property name="Output List.[02].DataType" value="String" />
                                              <property name="Output List.[03]" value="e.Title" />
                                              <property name="Output List.[03].Table" value="e" />
                                              <property name="Output List.[03].Column" value="Title" />
                                              <property name="Output List.[03].DataType" value="String" />
                                              <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                              <property name="Output List.[04].Table" value="e" />
                                              <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                              <property name="Output List.[04].DataType" value="String" />
                                              <property name="Output List.[05]" value="e.BirthDate" />
                                              <property name="Output List.[05].Table" value="e" />
                                              <property name="Output List.[05].Column" value="BirthDate" />
                                              <property name="Output List.[05].DataType" value="DateTime" />
                                              <property name="Output List.[06]" value="e.HireDate" />
                                              <property name="Output List.[06].Table" value="e" />
                                              <property name="Output List.[06].Column" value="HireDate" />
                                              <property name="Output List.[06].DataType" value="DateTime" />
                                              <property name="Output List.[07]" value="e.Address" />
                                              <property name="Output List.[07].Table" value="e" />
                                              <property name="Output List.[07].Column" value="Address" />
                                              <property name="Output List.[07].DataType" value="String" />
                                              <property name="Output List.[08]" value="e.City" />
                                              <property name="Output List.[08].Table" value="e" />
                                              <property name="Output List.[08].Column" value="City" />
                                              <property name="Output List.[08].DataType" value="String" />
                                              <property name="Output List.[09]" value="e.Region" />
                                              <property name="Output List.[09].Table" value="e" />
                                              <property name="Output List.[09].Column" value="Region" />
                                              <property name="Output List.[09].DataType" value="String" />
                                              <property name="Output List.[10]" value="e.PostalCode" />
                                              <property name="Output List.[10].Table" value="e" />
                                              <property name="Output List.[10].Column" value="PostalCode" />
                                              <property name="Output List.[10].DataType" value="String" />
                                              <property name="Output List.[11]" value="e.Country" />
                                              <property name="Output List.[11].Table" value="e" />
                                              <property name="Output List.[11].Column" value="Country" />
                                              <property name="Output List.[11].DataType" value="String" />
                                              <property name="Output List.[12]" value="e.HomePhone" />
                                              <property name="Output List.[12].Table" value="e" />
                                              <property name="Output List.[12].Column" value="HomePhone" />
                                              <property name="Output List.[12].DataType" value="String" />
                                              <property name="Output List.[13]" value="e.Extension" />
                                              <property name="Output List.[13].Table" value="e" />
                                              <property name="Output List.[13].Column" value="Extension" />
                                              <property name="Output List.[13].DataType" value="String" />
                                              <property name="Output List.[14]" value="e.Photo" />
                                              <property name="Output List.[14].Table" value="e" />
                                              <property name="Output List.[14].Column" value="Photo" />
                                              <property name="Output List.[14].DataType" value="Byte[]" />
                                              <property name="Output List.[15]" value="e.Notes" />
                                              <property name="Output List.[15].Table" value="e" />
                                              <property name="Output List.[15].Column" value="Notes" />
                                              <property name="Output List.[15].DataType" value="String" />
                                              <property name="Output List.[16]" value="e.ReportsTo" />
                                              <property name="Output List.[16].Table" value="e" />
                                              <property name="Output List.[16].Column" value="ReportsTo" />
                                              <property name="Output List.[16].DataType" value="Int32" />
                                              <property name="Output List.[17]" value="e.PhotoPath" />
                                              <property name="Output List.[17].Table" value="e" />
                                              <property name="Output List.[17].Column" value="PhotoPath" />
                                              <property name="Output List.[17].DataType" value="String" />
                                              <property name="Statistics.Open Count" value="1" />
                                              <property name="Statistics.Row Count" value="9" />
                                              <property name="Statistics.Average Row Count" value="9" />
                                            </properties>
                                            <input />
                                          </element>
                                        </input>
                                      </element>
                                    </input>
                                  </element>
                                  <element operator="ComputeScalar">
                                    <properties>
                                      <property name="Output List.[00]" value="e.EmployeeID" />
                                      <property name="Output List.[00].Table" value="e" />
                                      <property name="Output List.[00].Column" value="EmployeeID" />
                                      <property name="Output List.[00].DataType" value="Int32" />
                                      <property name="Output List.[01]" value="e.LastName" />
                                      <property name="Output List.[01].Table" value="e" />
                                      <property name="Output List.[01].Column" value="LastName" />
                                      <property name="Output List.[01].DataType" value="String" />
                                      <property name="Output List.[02]" value="e.FirstName" />
                                      <property name="Output List.[02].Table" value="e" />
                                      <property name="Output List.[02].Column" value="FirstName" />
                                      <property name="Output List.[02].DataType" value="String" />
                                      <property name="Output List.[03]" value="e.Title" />
                                      <property name="Output List.[03].Table" value="e" />
                                      <property name="Output List.[03].Column" value="Title" />
                                      <property name="Output List.[03].DataType" value="String" />
                                      <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                      <property name="Output List.[04].Table" value="e" />
                                      <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                      <property name="Output List.[04].DataType" value="String" />
                                      <property name="Output List.[05]" value="e.BirthDate" />
                                      <property name="Output List.[05].Table" value="e" />
                                      <property name="Output List.[05].Column" value="BirthDate" />
                                      <property name="Output List.[05].DataType" value="DateTime" />
                                      <property name="Output List.[06]" value="e.HireDate" />
                                      <property name="Output List.[06].Table" value="e" />
                                      <property name="Output List.[06].Column" value="HireDate" />
                                      <property name="Output List.[06].DataType" value="DateTime" />
                                      <property name="Output List.[07]" value="e.Address" />
                                      <property name="Output List.[07].Table" value="e" />
                                      <property name="Output List.[07].Column" value="Address" />
                                      <property name="Output List.[07].DataType" value="String" />
                                      <property name="Output List.[08]" value="e.City" />
                                      <property name="Output List.[08].Table" value="e" />
                                      <property name="Output List.[08].Column" value="City" />
                                      <property name="Output List.[08].DataType" value="String" />
                                      <property name="Output List.[09]" value="e.Region" />
                                      <property name="Output List.[09].Table" value="e" />
                                      <property name="Output List.[09].Column" value="Region" />
                                      <property name="Output List.[09].DataType" value="String" />
                                      <property name="Output List.[10]" value="e.PostalCode" />
                                      <property name="Output List.[10].Table" value="e" />
                                      <property name="Output List.[10].Column" value="PostalCode" />
                                      <property name="Output List.[10].DataType" value="String" />
                                      <property name="Output List.[11]" value="e.Country" />
                                      <property name="Output List.[11].Table" value="e" />
                                      <property name="Output List.[11].Column" value="Country" />
                                      <property name="Output List.[11].DataType" value="String" />
                                      <property name="Output List.[12]" value="e.HomePhone" />
                                      <property name="Output List.[12].Table" value="e" />
                                      <property name="Output List.[12].Column" value="HomePhone" />
                                      <property name="Output List.[12].DataType" value="String" />
                                      <property name="Output List.[13]" value="e.Extension" />
                                      <property name="Output List.[13].Table" value="e" />
                                      <property name="Output List.[13].Column" value="Extension" />
                                      <property name="Output List.[13].DataType" value="String" />
                                      <property name="Output List.[14]" value="e.Photo" />
                                      <property name="Output List.[14].Table" value="e" />
                                      <property name="Output List.[14].Column" value="Photo" />
                                      <property name="Output List.[14].DataType" value="Byte[]" />
                                      <property name="Output List.[15]" value="e.Notes" />
                                      <property name="Output List.[15].Table" value="e" />
                                      <property name="Output List.[15].Column" value="Notes" />
                                      <property name="Output List.[15].DataType" value="String" />
                                      <property name="Output List.[16]" value="e.ReportsTo" />
                                      <property name="Output List.[16].Table" value="e" />
                                      <property name="Output List.[16].Column" value="ReportsTo" />
                                      <property name="Output List.[16].DataType" value="Int32" />
                                      <property name="Output List.[17]" value="e.PhotoPath" />
                                      <property name="Output List.[17].Table" value="e" />
                                      <property name="Output List.[17].Column" value="PhotoPath" />
                                      <property name="Output List.[17].DataType" value="String" />
                                      <property name="Output List.[18]" value="Expr1038" />
                                      <property name="Output List.[18].Column" value="Expr1038" />
                                      <property name="Output List.[18].DataType" value="Int32" />
                                      <property name="Output List.[19]" value="Expr1039" />
                                      <property name="Output List.[19].Column" value="Expr1039" />
                                      <property name="Output List.[19].DataType" value="String" />
                                      <property name="Statistics.Open Count" value="1" />
                                      <property name="Statistics.Row Count" value="1" />
                                      <property name="Statistics.Average Row Count" value="1" />
                                      <property name="Defined Values.[0]" value="Expr1038 = 0" />
                                      <property name="Defined Values.[0].Target" value="Expr1038" />
                                      <property name="Defined Values.[0].DataType" value="Int32" />
                                      <property name="Defined Values.[0].Source" value="0" />
                                      <property name="Defined Values.[1]" value="Expr1039 = e.EmployeeID.ToString()" />
                                      <property name="Defined Values.[1].Target" value="Expr1039" />
                                      <property name="Defined Values.[1].DataType" value="String" />
                                      <property name="Defined Values.[1].Source" value="e.EmployeeID.ToString()" />
                                    </properties>
                                    <input>
                                      <element operator="Filter">
                                        <properties>
                                          <property name="Output List.[00]" value="e.EmployeeID" />
                                          <property name="Output List.[00].Table" value="e" />
                                          <property name="Output List.[00].Column" value="EmployeeID" />
                                          <property name="Output List.[00].DataType" value="Int32" />
                                          <property name="Output List.[01]" value="e.LastName" />
                                          <property name="Output List.[01].Table" value="e" />
                                          <property name="Output List.[01].Column" value="LastName" />
                                          <property name="Output List.[01].DataType" value="String" />
                                          <property name="Output List.[02]" value="e.FirstName" />
                                          <property name="Output List.[02].Table" value="e" />
                                          <property name="Output List.[02].Column" value="FirstName" />
                                          <property name="Output List.[02].DataType" value="String" />
                                          <property name="Output List.[03]" value="e.Title" />
                                          <property name="Output List.[03].Table" value="e" />
                                          <property name="Output List.[03].Column" value="Title" />
                                          <property name="Output List.[03].DataType" value="String" />
                                          <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                          <property name="Output List.[04].Table" value="e" />
                                          <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                          <property name="Output List.[04].DataType" value="String" />
                                          <property name="Output List.[05]" value="e.BirthDate" />
                                          <property name="Output List.[05].Table" value="e" />
                                          <property name="Output List.[05].Column" value="BirthDate" />
                                          <property name="Output List.[05].DataType" value="DateTime" />
                                          <property name="Output List.[06]" value="e.HireDate" />
                                          <property name="Output List.[06].Table" value="e" />
                                          <property name="Output List.[06].Column" value="HireDate" />
                                          <property name="Output List.[06].DataType" value="DateTime" />
                                          <property name="Output List.[07]" value="e.Address" />
                                          <property name="Output List.[07].Table" value="e" />
                                          <property name="Output List.[07].Column" value="Address" />
                                          <property name="Output List.[07].DataType" value="String" />
                                          <property name="Output List.[08]" value="e.City" />
                                          <property name="Output List.[08].Table" value="e" />
                                          <property name="Output List.[08].Column" value="City" />
                                          <property name="Output List.[08].DataType" value="String" />
                                          <property name="Output List.[09]" value="e.Region" />
                                          <property name="Output List.[09].Table" value="e" />
                                          <property name="Output List.[09].Column" value="Region" />
                                          <property name="Output List.[09].DataType" value="String" />
                                          <property name="Output List.[10]" value="e.PostalCode" />
                                          <property name="Output List.[10].Table" value="e" />
                                          <property name="Output List.[10].Column" value="PostalCode" />
                                          <property name="Output List.[10].DataType" value="String" />
                                          <property name="Output List.[11]" value="e.Country" />
                                          <property name="Output List.[11].Table" value="e" />
                                          <property name="Output List.[11].Column" value="Country" />
                                          <property name="Output List.[11].DataType" value="String" />
                                          <property name="Output List.[12]" value="e.HomePhone" />
                                          <property name="Output List.[12].Table" value="e" />
                                          <property name="Output List.[12].Column" value="HomePhone" />
                                          <property name="Output List.[12].DataType" value="String" />
                                          <property name="Output List.[13]" value="e.Extension" />
                                          <property name="Output List.[13].Table" value="e" />
                                          <property name="Output List.[13].Column" value="Extension" />
                                          <property name="Output List.[13].DataType" value="String" />
                                          <property name="Output List.[14]" value="e.Photo" />
                                          <property name="Output List.[14].Table" value="e" />
                                          <property name="Output List.[14].Column" value="Photo" />
                                          <property name="Output List.[14].DataType" value="Byte[]" />
                                          <property name="Output List.[15]" value="e.Notes" />
                                          <property name="Output List.[15].Table" value="e" />
                                          <property name="Output List.[15].Column" value="Notes" />
                                          <property name="Output List.[15].DataType" value="String" />
                                          <property name="Output List.[16]" value="e.ReportsTo" />
                                          <property name="Output List.[16].Table" value="e" />
                                          <property name="Output List.[16].Column" value="ReportsTo" />
                                          <property name="Output List.[16].DataType" value="Int32" />
                                          <property name="Output List.[17]" value="e.PhotoPath" />
                                          <property name="Output List.[17].Table" value="e" />
                                          <property name="Output List.[17].Column" value="PhotoPath" />
                                          <property name="Output List.[17].DataType" value="String" />
                                          <property name="Statistics.Open Count" value="1" />
                                          <property name="Statistics.Row Count" value="1" />
                                          <property name="Statistics.Average Row Count" value="1" />
                                          <property name="Predicate" value="e.ReportsTo IS NULL" />
                                        </properties>
                                        <input>
                                          <element operator="TableScan">
                                            <properties>
                                              <property name="Table" value="Employees AS e" />
                                              <property name="Output List.[00]" value="e.EmployeeID" />
                                              <property name="Output List.[00].Table" value="e" />
                                              <property name="Output List.[00].Column" value="EmployeeID" />
                                              <property name="Output List.[00].DataType" value="Int32" />
                                              <property name="Output List.[01]" value="e.LastName" />
                                              <property name="Output List.[01].Table" value="e" />
                                              <property name="Output List.[01].Column" value="LastName" />
                                              <property name="Output List.[01].DataType" value="String" />
                                              <property name="Output List.[02]" value="e.FirstName" />
                                              <property name="Output List.[02].Table" value="e" />
                                              <property name="Output List.[02].Column" value="FirstName" />
                                              <property name="Output List.[02].DataType" value="String" />
                                              <property name="Output List.[03]" value="e.Title" />
                                              <property name="Output List.[03].Table" value="e" />
                                              <property name="Output List.[03].Column" value="Title" />
                                              <property name="Output List.[03].DataType" value="String" />
                                              <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                              <property name="Output List.[04].Table" value="e" />
                                              <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                              <property name="Output List.[04].DataType" value="String" />
                                              <property name="Output List.[05]" value="e.BirthDate" />
                                              <property name="Output List.[05].Table" value="e" />
                                              <property name="Output List.[05].Column" value="BirthDate" />
                                              <property name="Output List.[05].DataType" value="DateTime" />
                                              <property name="Output List.[06]" value="e.HireDate" />
                                              <property name="Output List.[06].Table" value="e" />
                                              <property name="Output List.[06].Column" value="HireDate" />
                                              <property name="Output List.[06].DataType" value="DateTime" />
                                              <property name="Output List.[07]" value="e.Address" />
                                              <property name="Output List.[07].Table" value="e" />
                                              <property name="Output List.[07].Column" value="Address" />
                                              <property name="Output List.[07].DataType" value="String" />
                                              <property name="Output List.[08]" value="e.City" />
                                              <property name="Output List.[08].Table" value="e" />
                                              <property name="Output List.[08].Column" value="City" />
                                              <property name="Output List.[08].DataType" value="String" />
                                              <property name="Output List.[09]" value="e.Region" />
                                              <property name="Output List.[09].Table" value="e" />
                                              <property name="Output List.[09].Column" value="Region" />
                                              <property name="Output List.[09].DataType" value="String" />
                                              <property name="Output List.[10]" value="e.PostalCode" />
                                              <property name="Output List.[10].Table" value="e" />
                                              <property name="Output List.[10].Column" value="PostalCode" />
                                              <property name="Output List.[10].DataType" value="String" />
                                              <property name="Output List.[11]" value="e.Country" />
                                              <property name="Output List.[11].Table" value="e" />
                                              <property name="Output List.[11].Column" value="Country" />
                                              <property name="Output List.[11].DataType" value="String" />
                                              <property name="Output List.[12]" value="e.HomePhone" />
                                              <property name="Output List.[12].Table" value="e" />
                                              <property name="Output List.[12].Column" value="HomePhone" />
                                              <property name="Output List.[12].DataType" value="String" />
                                              <property name="Output List.[13]" value="e.Extension" />
                                              <property name="Output List.[13].Table" value="e" />
                                              <property name="Output List.[13].Column" value="Extension" />
                                              <property name="Output List.[13].DataType" value="String" />
                                              <property name="Output List.[14]" value="e.Photo" />
                                              <property name="Output List.[14].Table" value="e" />
                                              <property name="Output List.[14].Column" value="Photo" />
                                              <property name="Output List.[14].DataType" value="Byte[]" />
                                              <property name="Output List.[15]" value="e.Notes" />
                                              <property name="Output List.[15].Table" value="e" />
                                              <property name="Output List.[15].Column" value="Notes" />
                                              <property name="Output List.[15].DataType" value="String" />
                                              <property name="Output List.[16]" value="e.ReportsTo" />
                                              <property name="Output List.[16].Table" value="e" />
                                              <property name="Output List.[16].Column" value="ReportsTo" />
                                              <property name="Output List.[16].DataType" value="Int32" />
                                              <property name="Output List.[17]" value="e.PhotoPath" />
                                              <property name="Output List.[17].Table" value="e" />
                                              <property name="Output List.[17].Column" value="PhotoPath" />
                                              <property name="Output List.[17].DataType" value="String" />
                                              <property name="Statistics.Open Count" value="1" />
                                              <property name="Statistics.Row Count" value="9" />
                                              <property name="Statistics.Average Row Count" value="9" />
                                            </properties>
                                            <input />
                                          </element>
                                        </input>
                                      </element>
                                    </input>
                                  </element>
                                </input>
                              </element>
                            </input>
                          </element>
                          <element operator="Assert">
                            <properties>
                              <property name="Output List.[00]" value="Expr1082" />
                              <property name="Output List.[00].Column" value="Expr1082" />
                              <property name="Output List.[00].DataType" value="Int32" />
                              <property name="Output List.[01]" value="Union1123" />
                              <property name="Output List.[01].Column" value="Union1123" />
                              <property name="Output List.[01].DataType" value="Int32" />
                              <property name="Output List.[02]" value="Union1124" />
                              <property name="Output List.[02].Column" value="Union1124" />
                              <property name="Output List.[02].DataType" value="String" />
                              <property name="Output List.[03]" value="Union1125" />
                              <property name="Output List.[03].Column" value="Union1125" />
                              <property name="Output List.[03].DataType" value="String" />
                              <property name="Output List.[04]" value="Union1126" />
                              <property name="Output List.[04].Column" value="Union1126" />
                              <property name="Output List.[04].DataType" value="String" />
                              <property name="Output List.[05]" value="Union1127" />
                              <property name="Output List.[05].Column" value="Union1127" />
                              <property name="Output List.[05].DataType" value="String" />
                              <property name="Output List.[06]" value="Union1128" />
                              <property name="Output List.[06].Column" value="Union1128" />
                              <property name="Output List.[06].DataType" value="DateTime" />
                              <property name="Output List.[07]" value="Union1129" />
                              <property name="Output List.[07].Column" value="Union1129" />
                              <property name="Output List.[07].DataType" value="DateTime" />
                              <property name="Output List.[08]" value="Union1130" />
                              <property name="Output List.[08].Column" value="Union1130" />
                              <property name="Output List.[08].DataType" value="String" />
                              <property name="Output List.[09]" value="Union1131" />
                              <property name="Output List.[09].Column" value="Union1131" />
                              <property name="Output List.[09].DataType" value="String" />
                              <property name="Output List.[10]" value="Union1132" />
                              <property name="Output List.[10].Column" value="Union1132" />
                              <property name="Output List.[10].DataType" value="String" />
                              <property name="Output List.[11]" value="Union1133" />
                              <property name="Output List.[11].Column" value="Union1133" />
                              <property name="Output List.[11].DataType" value="String" />
                              <property name="Output List.[12]" value="Union1134" />
                              <property name="Output List.[12].Column" value="Union1134" />
                              <property name="Output List.[12].DataType" value="String" />
                              <property name="Output List.[13]" value="Union1135" />
                              <property name="Output List.[13].Column" value="Union1135" />
                              <property name="Output List.[13].DataType" value="String" />
                              <property name="Output List.[14]" value="Union1136" />
                              <property name="Output List.[14].Column" value="Union1136" />
                              <property name="Output List.[14].DataType" value="String" />
                              <property name="Output List.[15]" value="Union1137" />
                              <property name="Output List.[15].Column" value="Union1137" />
                              <property name="Output List.[15].DataType" value="Byte[]" />
                              <property name="Output List.[16]" value="Union1138" />
                              <property name="Output List.[16].Column" value="Union1138" />
                              <property name="Output List.[16].DataType" value="String" />
                              <property name="Output List.[17]" value="Union1139" />
                              <property name="Output List.[17].Column" value="Union1139" />
                              <property name="Output List.[17].DataType" value="Int32" />
                              <property name="Output List.[18]" value="Union1140" />
                              <property name="Output List.[18].Column" value="Union1140" />
                              <property name="Output List.[18].DataType" value="String" />
                              <property name="Output List.[19]" value="Union1141" />
                              <property name="Output List.[19].Column" value="Union1141" />
                              <property name="Output List.[19].DataType" value="Int32" />
                              <property name="Output List.[20]" value="Union1142" />
                              <property name="Output List.[20].Column" value="Union1142" />
                              <property name="Output List.[20].DataType" value="String" />
                              <property name="Statistics.Open Count" value="1" />
                              <property name="Statistics.Row Count" value="44" />
                              <property name="Statistics.Average Row Count" value="44" />
                              <property name="Predicate" value="CASE WHEN Expr1082 &gt; 100 THEN 0 END" />
                            </properties>
                            <input>
                              <element operator="NestedLoops">
                                <properties>
                                  <property name="Output List.[00]" value="Expr1082" />
                                  <property name="Output List.[00].Column" value="Expr1082" />
                                  <property name="Output List.[00].DataType" value="Int32" />
                                  <property name="Output List.[01]" value="Union1123" />
                                  <property name="Output List.[01].Column" value="Union1123" />
                                  <property name="Output List.[01].DataType" value="Int32" />
                                  <property name="Output List.[02]" value="Union1124" />
                                  <property name="Output List.[02].Column" value="Union1124" />
                                  <property name="Output List.[02].DataType" value="String" />
                                  <property name="Output List.[03]" value="Union1125" />
                                  <property name="Output List.[03].Column" value="Union1125" />
                                  <property name="Output List.[03].DataType" value="String" />
                                  <property name="Output List.[04]" value="Union1126" />
                                  <property name="Output List.[04].Column" value="Union1126" />
                                  <property name="Output List.[04].DataType" value="String" />
                                  <property name="Output List.[05]" value="Union1127" />
                                  <property name="Output List.[05].Column" value="Union1127" />
                                  <property name="Output List.[05].DataType" value="String" />
                                  <property name="Output List.[06]" value="Union1128" />
                                  <property name="Output List.[06].Column" value="Union1128" />
                                  <property name="Output List.[06].DataType" value="DateTime" />
                                  <property name="Output List.[07]" value="Union1129" />
                                  <property name="Output List.[07].Column" value="Union1129" />
                                  <property name="Output List.[07].DataType" value="DateTime" />
                                  <property name="Output List.[08]" value="Union1130" />
                                  <property name="Output List.[08].Column" value="Union1130" />
                                  <property name="Output List.[08].DataType" value="String" />
                                  <property name="Output List.[09]" value="Union1131" />
                                  <property name="Output List.[09].Column" value="Union1131" />
                                  <property name="Output List.[09].DataType" value="String" />
                                  <property name="Output List.[10]" value="Union1132" />
                                  <property name="Output List.[10].Column" value="Union1132" />
                                  <property name="Output List.[10].DataType" value="String" />
                                  <property name="Output List.[11]" value="Union1133" />
                                  <property name="Output List.[11].Column" value="Union1133" />
                                  <property name="Output List.[11].DataType" value="String" />
                                  <property name="Output List.[12]" value="Union1134" />
                                  <property name="Output List.[12].Column" value="Union1134" />
                                  <property name="Output List.[12].DataType" value="String" />
                                  <property name="Output List.[13]" value="Union1135" />
                                  <property name="Output List.[13].Column" value="Union1135" />
                                  <property name="Output List.[13].DataType" value="String" />
                                  <property name="Output List.[14]" value="Union1136" />
                                  <property name="Output List.[14].Column" value="Union1136" />
                                  <property name="Output List.[14].DataType" value="String" />
                                  <property name="Output List.[15]" value="Union1137" />
                                  <property name="Output List.[15].Column" value="Union1137" />
                                  <property name="Output List.[15].DataType" value="Byte[]" />
                                  <property name="Output List.[16]" value="Union1138" />
                                  <property name="Output List.[16].Column" value="Union1138" />
                                  <property name="Output List.[16].DataType" value="String" />
                                  <property name="Output List.[17]" value="Union1139" />
                                  <property name="Output List.[17].Column" value="Union1139" />
                                  <property name="Output List.[17].DataType" value="Int32" />
                                  <property name="Output List.[18]" value="Union1140" />
                                  <property name="Output List.[18].Column" value="Union1140" />
                                  <property name="Output List.[18].DataType" value="String" />
                                  <property name="Output List.[19]" value="Union1141" />
                                  <property name="Output List.[19].Column" value="Union1141" />
                                  <property name="Output List.[19].DataType" value="Int32" />
                                  <property name="Output List.[20]" value="Union1142" />
                                  <property name="Output List.[20].Column" value="Union1142" />
                                  <property name="Output List.[20].DataType" value="String" />
                                  <property name="Logical Operator" value="Inner Join" />
                                  <property name="Statistics.Open Count" value="1" />
                                  <property name="Statistics.Row Count" value="44" />
                                  <property name="Statistics.Average Row Count" value="44" />
                                  <property name="Outer References.[0]" value="Expr1062" />
                                  <property name="Outer References.[0].Column" value="Expr1062" />
                                  <property name="Outer References.[0].DataType" value="Int32" />
                                  <property name="Outer References.[1]" value="Expr1080" />
                                  <property name="Outer References.[1].Column" value="Expr1080" />
                                  <property name="Outer References.[1].DataType" value="Int32" />
                                  <property name="Outer References.[2]" value="Expr1081" />
                                  <property name="Outer References.[2].Column" value="Expr1081" />
                                  <property name="Outer References.[2].DataType" value="String" />
                                </properties>
                                <input>
                                  <element operator="ComputeScalar">
                                    <properties>
                                      <property name="Output List.[0]" value="Expr1062" />
                                      <property name="Output List.[0].Column" value="Expr1062" />
                                      <property name="Output List.[0].DataType" value="Int32" />
                                      <property name="Output List.[1]" value="Expr1080" />
                                      <property name="Output List.[1].Column" value="Expr1080" />
                                      <property name="Output List.[1].DataType" value="Int32" />
                                      <property name="Output List.[2]" value="Expr1081" />
                                      <property name="Output List.[2].Column" value="Expr1081" />
                                      <property name="Output List.[2].DataType" value="String" />
                                      <property name="Output List.[3]" value="Expr1082" />
                                      <property name="Output List.[3].Column" value="Expr1082" />
                                      <property name="Output List.[3].DataType" value="Int32" />
                                      <property name="Statistics.Open Count" value="1" />
                                      <property name="Statistics.Row Count" value="46" />
                                      <property name="Statistics.Average Row Count" value="46" />
                                      <property name="Defined Values.[0]" value="Expr1082 = Expr1061 + 1" />
                                      <property name="Defined Values.[0].Target" value="Expr1082" />
                                      <property name="Defined Values.[0].DataType" value="Int32" />
                                      <property name="Defined Values.[0].Source" value="Expr1061 + 1" />
                                    </properties>
                                    <input>
                                      <element operator="TableSpool">
                                        <properties>
                                          <property name="Output List.[00]" value="Expr1061" />
                                          <property name="Output List.[00].Column" value="Expr1061" />
                                          <property name="Output List.[00].DataType" value="Int32" />
                                          <property name="Output List.[01]" value="Expr1062" />
                                          <property name="Output List.[01].Column" value="Expr1062" />
                                          <property name="Output List.[01].DataType" value="Int32" />
                                          <property name="Output List.[02]" value="Expr1063" />
                                          <property name="Output List.[02].Column" value="Expr1063" />
                                          <property name="Output List.[02].DataType" value="String" />
                                          <property name="Output List.[03]" value="Expr1064" />
                                          <property name="Output List.[03].Column" value="Expr1064" />
                                          <property name="Output List.[03].DataType" value="String" />
                                          <property name="Output List.[04]" value="Expr1065" />
                                          <property name="Output List.[04].Column" value="Expr1065" />
                                          <property name="Output List.[04].DataType" value="String" />
                                          <property name="Output List.[05]" value="Expr1066" />
                                          <property name="Output List.[05].Column" value="Expr1066" />
                                          <property name="Output List.[05].DataType" value="String" />
                                          <property name="Output List.[06]" value="Expr1067" />
                                          <property name="Output List.[06].Column" value="Expr1067" />
                                          <property name="Output List.[06].DataType" value="DateTime" />
                                          <property name="Output List.[07]" value="Expr1068" />
                                          <property name="Output List.[07].Column" value="Expr1068" />
                                          <property name="Output List.[07].DataType" value="DateTime" />
                                          <property name="Output List.[08]" value="Expr1069" />
                                          <property name="Output List.[08].Column" value="Expr1069" />
                                          <property name="Output List.[08].DataType" value="String" />
                                          <property name="Output List.[09]" value="Expr1070" />
                                          <property name="Output List.[09].Column" value="Expr1070" />
                                          <property name="Output List.[09].DataType" value="String" />
                                          <property name="Output List.[10]" value="Expr1071" />
                                          <property name="Output List.[10].Column" value="Expr1071" />
                                          <property name="Output List.[10].DataType" value="String" />
                                          <property name="Output List.[11]" value="Expr1072" />
                                          <property name="Output List.[11].Column" value="Expr1072" />
                                          <property name="Output List.[11].DataType" value="String" />
                                          <property name="Output List.[12]" value="Expr1073" />
                                          <property name="Output List.[12].Column" value="Expr1073" />
                                          <property name="Output List.[12].DataType" value="String" />
                                          <property name="Output List.[13]" value="Expr1074" />
                                          <property name="Output List.[13].Column" value="Expr1074" />
                                          <property name="Output List.[13].DataType" value="String" />
                                          <property name="Output List.[14]" value="Expr1075" />
                                          <property name="Output List.[14].Column" value="Expr1075" />
                                          <property name="Output List.[14].DataType" value="String" />
                                          <property name="Output List.[15]" value="Expr1076" />
                                          <property name="Output List.[15].Column" value="Expr1076" />
                                          <property name="Output List.[15].DataType" value="Byte[]" />
                                          <property name="Output List.[16]" value="Expr1077" />
                                          <property name="Output List.[16].Column" value="Expr1077" />
                                          <property name="Output List.[16].DataType" value="String" />
                                          <property name="Output List.[17]" value="Expr1078" />
                                          <property name="Output List.[17].Column" value="Expr1078" />
                                          <property name="Output List.[17].DataType" value="Int32" />
                                          <property name="Output List.[18]" value="Expr1079" />
                                          <property name="Output List.[18].Column" value="Expr1079" />
                                          <property name="Output List.[18].DataType" value="String" />
                                          <property name="Output List.[19]" value="Expr1080" />
                                          <property name="Output List.[19].Column" value="Expr1080" />
                                          <property name="Output List.[19].DataType" value="Int32" />
                                          <property name="Output List.[20]" value="Expr1081" />
                                          <property name="Output List.[20].Column" value="Expr1081" />
                                          <property name="Output List.[20].DataType" value="String" />
                                          <property name="Statistics.Open Count" value="1" />
                                          <property name="Statistics.Row Count" value="46" />
                                          <property name="Statistics.Average Row Count" value="46" />
                                          <property name="Logical Operator" value="Lazy Spool" />
                                          <property name="With Stack" value="True" />
                                        </properties>
                                        <input />
                                      </element>
                                    </input>
                                  </element>
                                  <element operator="Concatenation">
                                    <properties>
                                      <property name="Output List.[00]" value="Union1123" />
                                      <property name="Output List.[00].Column" value="Union1123" />
                                      <property name="Output List.[00].DataType" value="Int32" />
                                      <property name="Output List.[01]" value="Union1124" />
                                      <property name="Output List.[01].Column" value="Union1124" />
                                      <property name="Output List.[01].DataType" value="String" />
                                      <property name="Output List.[02]" value="Union1125" />
                                      <property name="Output List.[02].Column" value="Union1125" />
                                      <property name="Output List.[02].DataType" value="String" />
                                      <property name="Output List.[03]" value="Union1126" />
                                      <property name="Output List.[03].Column" value="Union1126" />
                                      <property name="Output List.[03].DataType" value="String" />
                                      <property name="Output List.[04]" value="Union1127" />
                                      <property name="Output List.[04].Column" value="Union1127" />
                                      <property name="Output List.[04].DataType" value="String" />
                                      <property name="Output List.[05]" value="Union1128" />
                                      <property name="Output List.[05].Column" value="Union1128" />
                                      <property name="Output List.[05].DataType" value="DateTime" />
                                      <property name="Output List.[06]" value="Union1129" />
                                      <property name="Output List.[06].Column" value="Union1129" />
                                      <property name="Output List.[06].DataType" value="DateTime" />
                                      <property name="Output List.[07]" value="Union1130" />
                                      <property name="Output List.[07].Column" value="Union1130" />
                                      <property name="Output List.[07].DataType" value="String" />
                                      <property name="Output List.[08]" value="Union1131" />
                                      <property name="Output List.[08].Column" value="Union1131" />
                                      <property name="Output List.[08].DataType" value="String" />
                                      <property name="Output List.[09]" value="Union1132" />
                                      <property name="Output List.[09].Column" value="Union1132" />
                                      <property name="Output List.[09].DataType" value="String" />
                                      <property name="Output List.[10]" value="Union1133" />
                                      <property name="Output List.[10].Column" value="Union1133" />
                                      <property name="Output List.[10].DataType" value="String" />
                                      <property name="Output List.[11]" value="Union1134" />
                                      <property name="Output List.[11].Column" value="Union1134" />
                                      <property name="Output List.[11].DataType" value="String" />
                                      <property name="Output List.[12]" value="Union1135" />
                                      <property name="Output List.[12].Column" value="Union1135" />
                                      <property name="Output List.[12].DataType" value="String" />
                                      <property name="Output List.[13]" value="Union1136" />
                                      <property name="Output List.[13].Column" value="Union1136" />
                                      <property name="Output List.[13].DataType" value="String" />
                                      <property name="Output List.[14]" value="Union1137" />
                                      <property name="Output List.[14].Column" value="Union1137" />
                                      <property name="Output List.[14].DataType" value="Byte[]" />
                                      <property name="Output List.[15]" value="Union1138" />
                                      <property name="Output List.[15].Column" value="Union1138" />
                                      <property name="Output List.[15].DataType" value="String" />
                                      <property name="Output List.[16]" value="Union1139" />
                                      <property name="Output List.[16].Column" value="Union1139" />
                                      <property name="Output List.[16].DataType" value="Int32" />
                                      <property name="Output List.[17]" value="Union1140" />
                                      <property name="Output List.[17].Column" value="Union1140" />
                                      <property name="Output List.[17].DataType" value="String" />
                                      <property name="Output List.[18]" value="Union1141" />
                                      <property name="Output List.[18].Column" value="Union1141" />
                                      <property name="Output List.[18].DataType" value="Int32" />
                                      <property name="Output List.[19]" value="Union1142" />
                                      <property name="Output List.[19].Column" value="Union1142" />
                                      <property name="Output List.[19].DataType" value="String" />
                                      <property name="Statistics.Open Count" value="46" />
                                      <property name="Statistics.Row Count" value="44" />
                                      <property name="Statistics.Average Row Count" value="1" />
                                      <property name="Defined Values.Union1123" value="e.EmployeeID; e.EmployeeID" />
                                      <property name="Defined Values.Union1123.[0]" value="e.EmployeeID" />
                                      <property name="Defined Values.Union1123.[0].Table" value="e" />
                                      <property name="Defined Values.Union1123.[0].Column" value="EmployeeID" />
                                      <property name="Defined Values.Union1123.[0].DataType" value="Int32" />
                                      <property name="Defined Values.Union1123.[1]" value="e.EmployeeID" />
                                      <property name="Defined Values.Union1123.[1].Table" value="e" />
                                      <property name="Defined Values.Union1123.[1].Column" value="EmployeeID" />
                                      <property name="Defined Values.Union1123.[1].DataType" value="Int32" />
                                      <property name="Defined Values.Union1124" value="e.LastName; e.LastName" />
                                      <property name="Defined Values.Union1124.[0]" value="e.LastName" />
                                      <property name="Defined Values.Union1124.[0].Table" value="e" />
                                      <property name="Defined Values.Union1124.[0].Column" value="LastName" />
                                      <property name="Defined Values.Union1124.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1124.[1]" value="e.LastName" />
                                      <property name="Defined Values.Union1124.[1].Table" value="e" />
                                      <property name="Defined Values.Union1124.[1].Column" value="LastName" />
                                      <property name="Defined Values.Union1124.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1125" value="e.FirstName; e.FirstName" />
                                      <property name="Defined Values.Union1125.[0]" value="e.FirstName" />
                                      <property name="Defined Values.Union1125.[0].Table" value="e" />
                                      <property name="Defined Values.Union1125.[0].Column" value="FirstName" />
                                      <property name="Defined Values.Union1125.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1125.[1]" value="e.FirstName" />
                                      <property name="Defined Values.Union1125.[1].Table" value="e" />
                                      <property name="Defined Values.Union1125.[1].Column" value="FirstName" />
                                      <property name="Defined Values.Union1125.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1126" value="e.Title; e.Title" />
                                      <property name="Defined Values.Union1126.[0]" value="e.Title" />
                                      <property name="Defined Values.Union1126.[0].Table" value="e" />
                                      <property name="Defined Values.Union1126.[0].Column" value="Title" />
                                      <property name="Defined Values.Union1126.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1126.[1]" value="e.Title" />
                                      <property name="Defined Values.Union1126.[1].Table" value="e" />
                                      <property name="Defined Values.Union1126.[1].Column" value="Title" />
                                      <property name="Defined Values.Union1126.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1127" value="e.TitleOfCourtesy; e.TitleOfCourtesy" />
                                      <property name="Defined Values.Union1127.[0]" value="e.TitleOfCourtesy" />
                                      <property name="Defined Values.Union1127.[0].Table" value="e" />
                                      <property name="Defined Values.Union1127.[0].Column" value="TitleOfCourtesy" />
                                      <property name="Defined Values.Union1127.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1127.[1]" value="e.TitleOfCourtesy" />
                                      <property name="Defined Values.Union1127.[1].Table" value="e" />
                                      <property name="Defined Values.Union1127.[1].Column" value="TitleOfCourtesy" />
                                      <property name="Defined Values.Union1127.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1128" value="e.BirthDate; e.BirthDate" />
                                      <property name="Defined Values.Union1128.[0]" value="e.BirthDate" />
                                      <property name="Defined Values.Union1128.[0].Table" value="e" />
                                      <property name="Defined Values.Union1128.[0].Column" value="BirthDate" />
                                      <property name="Defined Values.Union1128.[0].DataType" value="DateTime" />
                                      <property name="Defined Values.Union1128.[1]" value="e.BirthDate" />
                                      <property name="Defined Values.Union1128.[1].Table" value="e" />
                                      <property name="Defined Values.Union1128.[1].Column" value="BirthDate" />
                                      <property name="Defined Values.Union1128.[1].DataType" value="DateTime" />
                                      <property name="Defined Values.Union1129" value="e.HireDate; e.HireDate" />
                                      <property name="Defined Values.Union1129.[0]" value="e.HireDate" />
                                      <property name="Defined Values.Union1129.[0].Table" value="e" />
                                      <property name="Defined Values.Union1129.[0].Column" value="HireDate" />
                                      <property name="Defined Values.Union1129.[0].DataType" value="DateTime" />
                                      <property name="Defined Values.Union1129.[1]" value="e.HireDate" />
                                      <property name="Defined Values.Union1129.[1].Table" value="e" />
                                      <property name="Defined Values.Union1129.[1].Column" value="HireDate" />
                                      <property name="Defined Values.Union1129.[1].DataType" value="DateTime" />
                                      <property name="Defined Values.Union1130" value="e.Address; e.Address" />
                                      <property name="Defined Values.Union1130.[0]" value="e.Address" />
                                      <property name="Defined Values.Union1130.[0].Table" value="e" />
                                      <property name="Defined Values.Union1130.[0].Column" value="Address" />
                                      <property name="Defined Values.Union1130.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1130.[1]" value="e.Address" />
                                      <property name="Defined Values.Union1130.[1].Table" value="e" />
                                      <property name="Defined Values.Union1130.[1].Column" value="Address" />
                                      <property name="Defined Values.Union1130.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1131" value="e.City; e.City" />
                                      <property name="Defined Values.Union1131.[0]" value="e.City" />
                                      <property name="Defined Values.Union1131.[0].Table" value="e" />
                                      <property name="Defined Values.Union1131.[0].Column" value="City" />
                                      <property name="Defined Values.Union1131.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1131.[1]" value="e.City" />
                                      <property name="Defined Values.Union1131.[1].Table" value="e" />
                                      <property name="Defined Values.Union1131.[1].Column" value="City" />
                                      <property name="Defined Values.Union1131.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1132" value="e.Region; e.Region" />
                                      <property name="Defined Values.Union1132.[0]" value="e.Region" />
                                      <property name="Defined Values.Union1132.[0].Table" value="e" />
                                      <property name="Defined Values.Union1132.[0].Column" value="Region" />
                                      <property name="Defined Values.Union1132.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1132.[1]" value="e.Region" />
                                      <property name="Defined Values.Union1132.[1].Table" value="e" />
                                      <property name="Defined Values.Union1132.[1].Column" value="Region" />
                                      <property name="Defined Values.Union1132.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1133" value="e.PostalCode; e.PostalCode" />
                                      <property name="Defined Values.Union1133.[0]" value="e.PostalCode" />
                                      <property name="Defined Values.Union1133.[0].Table" value="e" />
                                      <property name="Defined Values.Union1133.[0].Column" value="PostalCode" />
                                      <property name="Defined Values.Union1133.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1133.[1]" value="e.PostalCode" />
                                      <property name="Defined Values.Union1133.[1].Table" value="e" />
                                      <property name="Defined Values.Union1133.[1].Column" value="PostalCode" />
                                      <property name="Defined Values.Union1133.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1134" value="e.Country; e.Country" />
                                      <property name="Defined Values.Union1134.[0]" value="e.Country" />
                                      <property name="Defined Values.Union1134.[0].Table" value="e" />
                                      <property name="Defined Values.Union1134.[0].Column" value="Country" />
                                      <property name="Defined Values.Union1134.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1134.[1]" value="e.Country" />
                                      <property name="Defined Values.Union1134.[1].Table" value="e" />
                                      <property name="Defined Values.Union1134.[1].Column" value="Country" />
                                      <property name="Defined Values.Union1134.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1135" value="e.HomePhone; e.HomePhone" />
                                      <property name="Defined Values.Union1135.[0]" value="e.HomePhone" />
                                      <property name="Defined Values.Union1135.[0].Table" value="e" />
                                      <property name="Defined Values.Union1135.[0].Column" value="HomePhone" />
                                      <property name="Defined Values.Union1135.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1135.[1]" value="e.HomePhone" />
                                      <property name="Defined Values.Union1135.[1].Table" value="e" />
                                      <property name="Defined Values.Union1135.[1].Column" value="HomePhone" />
                                      <property name="Defined Values.Union1135.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1136" value="e.Extension; e.Extension" />
                                      <property name="Defined Values.Union1136.[0]" value="e.Extension" />
                                      <property name="Defined Values.Union1136.[0].Table" value="e" />
                                      <property name="Defined Values.Union1136.[0].Column" value="Extension" />
                                      <property name="Defined Values.Union1136.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1136.[1]" value="e.Extension" />
                                      <property name="Defined Values.Union1136.[1].Table" value="e" />
                                      <property name="Defined Values.Union1136.[1].Column" value="Extension" />
                                      <property name="Defined Values.Union1136.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1137" value="e.Photo; e.Photo" />
                                      <property name="Defined Values.Union1137.[0]" value="e.Photo" />
                                      <property name="Defined Values.Union1137.[0].Table" value="e" />
                                      <property name="Defined Values.Union1137.[0].Column" value="Photo" />
                                      <property name="Defined Values.Union1137.[0].DataType" value="Byte[]" />
                                      <property name="Defined Values.Union1137.[1]" value="e.Photo" />
                                      <property name="Defined Values.Union1137.[1].Table" value="e" />
                                      <property name="Defined Values.Union1137.[1].Column" value="Photo" />
                                      <property name="Defined Values.Union1137.[1].DataType" value="Byte[]" />
                                      <property name="Defined Values.Union1138" value="e.Notes; e.Notes" />
                                      <property name="Defined Values.Union1138.[0]" value="e.Notes" />
                                      <property name="Defined Values.Union1138.[0].Table" value="e" />
                                      <property name="Defined Values.Union1138.[0].Column" value="Notes" />
                                      <property name="Defined Values.Union1138.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1138.[1]" value="e.Notes" />
                                      <property name="Defined Values.Union1138.[1].Table" value="e" />
                                      <property name="Defined Values.Union1138.[1].Column" value="Notes" />
                                      <property name="Defined Values.Union1138.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1139" value="e.ReportsTo; e.ReportsTo" />
                                      <property name="Defined Values.Union1139.[0]" value="e.ReportsTo" />
                                      <property name="Defined Values.Union1139.[0].Table" value="e" />
                                      <property name="Defined Values.Union1139.[0].Column" value="ReportsTo" />
                                      <property name="Defined Values.Union1139.[0].DataType" value="Int32" />
                                      <property name="Defined Values.Union1139.[1]" value="e.ReportsTo" />
                                      <property name="Defined Values.Union1139.[1].Table" value="e" />
                                      <property name="Defined Values.Union1139.[1].Column" value="ReportsTo" />
                                      <property name="Defined Values.Union1139.[1].DataType" value="Int32" />
                                      <property name="Defined Values.Union1140" value="e.PhotoPath; e.PhotoPath" />
                                      <property name="Defined Values.Union1140.[0]" value="e.PhotoPath" />
                                      <property name="Defined Values.Union1140.[0].Table" value="e" />
                                      <property name="Defined Values.Union1140.[0].Column" value="PhotoPath" />
                                      <property name="Defined Values.Union1140.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1140.[1]" value="e.PhotoPath" />
                                      <property name="Defined Values.Union1140.[1].Table" value="e" />
                                      <property name="Defined Values.Union1140.[1].Column" value="PhotoPath" />
                                      <property name="Defined Values.Union1140.[1].DataType" value="String" />
                                      <property name="Defined Values.Union1141" value="Expr1101; Expr1121" />
                                      <property name="Defined Values.Union1141.[0]" value="Expr1101" />
                                      <property name="Defined Values.Union1141.[0].Column" value="Expr1101" />
                                      <property name="Defined Values.Union1141.[0].DataType" value="Int32" />
                                      <property name="Defined Values.Union1141.[1]" value="Expr1121" />
                                      <property name="Defined Values.Union1141.[1].Column" value="Expr1121" />
                                      <property name="Defined Values.Union1141.[1].DataType" value="Int32" />
                                      <property name="Defined Values.Union1142" value="Expr1102; Expr1122" />
                                      <property name="Defined Values.Union1142.[0]" value="Expr1102" />
                                      <property name="Defined Values.Union1142.[0].Column" value="Expr1102" />
                                      <property name="Defined Values.Union1142.[0].DataType" value="String" />
                                      <property name="Defined Values.Union1142.[1]" value="Expr1122" />
                                      <property name="Defined Values.Union1142.[1].Column" value="Expr1122" />
                                      <property name="Defined Values.Union1142.[1].DataType" value="String" />
                                    </properties>
                                    <input>
                                      <element operator="ComputeScalar">
                                        <properties>
                                          <property name="Output List.[00]" value="e.EmployeeID" />
                                          <property name="Output List.[00].Table" value="e" />
                                          <property name="Output List.[00].Column" value="EmployeeID" />
                                          <property name="Output List.[00].DataType" value="Int32" />
                                          <property name="Output List.[01]" value="e.LastName" />
                                          <property name="Output List.[01].Table" value="e" />
                                          <property name="Output List.[01].Column" value="LastName" />
                                          <property name="Output List.[01].DataType" value="String" />
                                          <property name="Output List.[02]" value="e.FirstName" />
                                          <property name="Output List.[02].Table" value="e" />
                                          <property name="Output List.[02].Column" value="FirstName" />
                                          <property name="Output List.[02].DataType" value="String" />
                                          <property name="Output List.[03]" value="e.Title" />
                                          <property name="Output List.[03].Table" value="e" />
                                          <property name="Output List.[03].Column" value="Title" />
                                          <property name="Output List.[03].DataType" value="String" />
                                          <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                          <property name="Output List.[04].Table" value="e" />
                                          <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                          <property name="Output List.[04].DataType" value="String" />
                                          <property name="Output List.[05]" value="e.BirthDate" />
                                          <property name="Output List.[05].Table" value="e" />
                                          <property name="Output List.[05].Column" value="BirthDate" />
                                          <property name="Output List.[05].DataType" value="DateTime" />
                                          <property name="Output List.[06]" value="e.HireDate" />
                                          <property name="Output List.[06].Table" value="e" />
                                          <property name="Output List.[06].Column" value="HireDate" />
                                          <property name="Output List.[06].DataType" value="DateTime" />
                                          <property name="Output List.[07]" value="e.Address" />
                                          <property name="Output List.[07].Table" value="e" />
                                          <property name="Output List.[07].Column" value="Address" />
                                          <property name="Output List.[07].DataType" value="String" />
                                          <property name="Output List.[08]" value="e.City" />
                                          <property name="Output List.[08].Table" value="e" />
                                          <property name="Output List.[08].Column" value="City" />
                                          <property name="Output List.[08].DataType" value="String" />
                                          <property name="Output List.[09]" value="e.Region" />
                                          <property name="Output List.[09].Table" value="e" />
                                          <property name="Output List.[09].Column" value="Region" />
                                          <property name="Output List.[09].DataType" value="String" />
                                          <property name="Output List.[10]" value="e.PostalCode" />
                                          <property name="Output List.[10].Table" value="e" />
                                          <property name="Output List.[10].Column" value="PostalCode" />
                                          <property name="Output List.[10].DataType" value="String" />
                                          <property name="Output List.[11]" value="e.Country" />
                                          <property name="Output List.[11].Table" value="e" />
                                          <property name="Output List.[11].Column" value="Country" />
                                          <property name="Output List.[11].DataType" value="String" />
                                          <property name="Output List.[12]" value="e.HomePhone" />
                                          <property name="Output List.[12].Table" value="e" />
                                          <property name="Output List.[12].Column" value="HomePhone" />
                                          <property name="Output List.[12].DataType" value="String" />
                                          <property name="Output List.[13]" value="e.Extension" />
                                          <property name="Output List.[13].Table" value="e" />
                                          <property name="Output List.[13].Column" value="Extension" />
                                          <property name="Output List.[13].DataType" value="String" />
                                          <property name="Output List.[14]" value="e.Photo" />
                                          <property name="Output List.[14].Table" value="e" />
                                          <property name="Output List.[14].Column" value="Photo" />
                                          <property name="Output List.[14].DataType" value="Byte[]" />
                                          <property name="Output List.[15]" value="e.Notes" />
                                          <property name="Output List.[15].Table" value="e" />
                                          <property name="Output List.[15].Column" value="Notes" />
                                          <property name="Output List.[15].DataType" value="String" />
                                          <property name="Output List.[16]" value="e.ReportsTo" />
                                          <property name="Output List.[16].Table" value="e" />
                                          <property name="Output List.[16].Column" value="ReportsTo" />
                                          <property name="Output List.[16].DataType" value="Int32" />
                                          <property name="Output List.[17]" value="e.PhotoPath" />
                                          <property name="Output List.[17].Table" value="e" />
                                          <property name="Output List.[17].Column" value="PhotoPath" />
                                          <property name="Output List.[17].DataType" value="String" />
                                          <property name="Output List.[18]" value="Expr1101" />
                                          <property name="Output List.[18].Column" value="Expr1101" />
                                          <property name="Output List.[18].DataType" value="Int32" />
                                          <property name="Output List.[19]" value="Expr1102" />
                                          <property name="Output List.[19].Column" value="Expr1102" />
                                          <property name="Output List.[19].DataType" value="String" />
                                          <property name="Statistics.Open Count" value="46" />
                                          <property name="Statistics.Row Count" value="22" />
                                          <property name="Statistics.Average Row Count" value="0" />
                                          <property name="Defined Values.[0]" value="Expr1101 = Expr1080 + 1" />
                                          <property name="Defined Values.[0].Target" value="Expr1101" />
                                          <property name="Defined Values.[0].DataType" value="Int32" />
                                          <property name="Defined Values.[0].Source" value="Expr1080 + 1" />
                                          <property name="Defined Values.[1]" value="Expr1102 = Expr1081 + '.' + e.EmployeeID.ToString()" />
                                          <property name="Defined Values.[1].Target" value="Expr1102" />
                                          <property name="Defined Values.[1].DataType" value="String" />
                                          <property name="Defined Values.[1].Source" value="Expr1081 + '.' + e.EmployeeID.ToString()" />
                                        </properties>
                                        <input>
                                          <element operator="IndexSpool">
                                            <properties>
                                              <property name="Output List.[00]" value="e.EmployeeID" />
                                              <property name="Output List.[00].Table" value="e" />
                                              <property name="Output List.[00].Column" value="EmployeeID" />
                                              <property name="Output List.[00].DataType" value="Int32" />
                                              <property name="Output List.[01]" value="e.LastName" />
                                              <property name="Output List.[01].Table" value="e" />
                                              <property name="Output List.[01].Column" value="LastName" />
                                              <property name="Output List.[01].DataType" value="String" />
                                              <property name="Output List.[02]" value="e.FirstName" />
                                              <property name="Output List.[02].Table" value="e" />
                                              <property name="Output List.[02].Column" value="FirstName" />
                                              <property name="Output List.[02].DataType" value="String" />
                                              <property name="Output List.[03]" value="e.Title" />
                                              <property name="Output List.[03].Table" value="e" />
                                              <property name="Output List.[03].Column" value="Title" />
                                              <property name="Output List.[03].DataType" value="String" />
                                              <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                              <property name="Output List.[04].Table" value="e" />
                                              <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                              <property name="Output List.[04].DataType" value="String" />
                                              <property name="Output List.[05]" value="e.BirthDate" />
                                              <property name="Output List.[05].Table" value="e" />
                                              <property name="Output List.[05].Column" value="BirthDate" />
                                              <property name="Output List.[05].DataType" value="DateTime" />
                                              <property name="Output List.[06]" value="e.HireDate" />
                                              <property name="Output List.[06].Table" value="e" />
                                              <property name="Output List.[06].Column" value="HireDate" />
                                              <property name="Output List.[06].DataType" value="DateTime" />
                                              <property name="Output List.[07]" value="e.Address" />
                                              <property name="Output List.[07].Table" value="e" />
                                              <property name="Output List.[07].Column" value="Address" />
                                              <property name="Output List.[07].DataType" value="String" />
                                              <property name="Output List.[08]" value="e.City" />
                                              <property name="Output List.[08].Table" value="e" />
                                              <property name="Output List.[08].Column" value="City" />
                                              <property name="Output List.[08].DataType" value="String" />
                                              <property name="Output List.[09]" value="e.Region" />
                                              <property name="Output List.[09].Table" value="e" />
                                              <property name="Output List.[09].Column" value="Region" />
                                              <property name="Output List.[09].DataType" value="String" />
                                              <property name="Output List.[10]" value="e.PostalCode" />
                                              <property name="Output List.[10].Table" value="e" />
                                              <property name="Output List.[10].Column" value="PostalCode" />
                                              <property name="Output List.[10].DataType" value="String" />
                                              <property name="Output List.[11]" value="e.Country" />
                                              <property name="Output List.[11].Table" value="e" />
                                              <property name="Output List.[11].Column" value="Country" />
                                              <property name="Output List.[11].DataType" value="String" />
                                              <property name="Output List.[12]" value="e.HomePhone" />
                                              <property name="Output List.[12].Table" value="e" />
                                              <property name="Output List.[12].Column" value="HomePhone" />
                                              <property name="Output List.[12].DataType" value="String" />
                                              <property name="Output List.[13]" value="e.Extension" />
                                              <property name="Output List.[13].Table" value="e" />
                                              <property name="Output List.[13].Column" value="Extension" />
                                              <property name="Output List.[13].DataType" value="String" />
                                              <property name="Output List.[14]" value="e.Photo" />
                                              <property name="Output List.[14].Table" value="e" />
                                              <property name="Output List.[14].Column" value="Photo" />
                                              <property name="Output List.[14].DataType" value="Byte[]" />
                                              <property name="Output List.[15]" value="e.Notes" />
                                              <property name="Output List.[15].Table" value="e" />
                                              <property name="Output List.[15].Column" value="Notes" />
                                              <property name="Output List.[15].DataType" value="String" />
                                              <property name="Output List.[16]" value="e.ReportsTo" />
                                              <property name="Output List.[16].Table" value="e" />
                                              <property name="Output List.[16].Column" value="ReportsTo" />
                                              <property name="Output List.[16].DataType" value="Int32" />
                                              <property name="Output List.[17]" value="e.PhotoPath" />
                                              <property name="Output List.[17].Table" value="e" />
                                              <property name="Output List.[17].Column" value="PhotoPath" />
                                              <property name="Output List.[17].DataType" value="String" />
                                              <property name="Statistics.Open Count" value="46" />
                                              <property name="Statistics.Row Count" value="22" />
                                              <property name="Statistics.Average Row Count" value="0" />
                                              <property name="Logical Operator" value="Eager Spool" />
                                              <property name="With Stack" value="False" />
                                              <property name="Index" value="e.ReportsTo" />
                                              <property name="Index.Table" value="e" />
                                              <property name="Index.Column" value="ReportsTo" />
                                              <property name="Index.DataType" value="Int32" />
                                              <property name="Probe" value="Expr1062" />
                                            </properties>
                                            <input>
                                              <element operator="TableScan">
                                                <properties>
                                                  <property name="Table" value="Employees AS e" />
                                                  <property name="Output List.[00]" value="e.EmployeeID" />
                                                  <property name="Output List.[00].Table" value="e" />
                                                  <property name="Output List.[00].Column" value="EmployeeID" />
                                                  <property name="Output List.[00].DataType" value="Int32" />
                                                  <property name="Output List.[01]" value="e.LastName" />
                                                  <property name="Output List.[01].Table" value="e" />
                                                  <property name="Output List.[01].Column" value="LastName" />
                                                  <property name="Output List.[01].DataType" value="String" />
                                                  <property name="Output List.[02]" value="e.FirstName" />
                                                  <property name="Output List.[02].Table" value="e" />
                                                  <property name="Output List.[02].Column" value="FirstName" />
                                                  <property name="Output List.[02].DataType" value="String" />
                                                  <property name="Output List.[03]" value="e.Title" />
                                                  <property name="Output List.[03].Table" value="e" />
                                                  <property name="Output List.[03].Column" value="Title" />
                                                  <property name="Output List.[03].DataType" value="String" />
                                                  <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                                  <property name="Output List.[04].Table" value="e" />
                                                  <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                                  <property name="Output List.[04].DataType" value="String" />
                                                  <property name="Output List.[05]" value="e.BirthDate" />
                                                  <property name="Output List.[05].Table" value="e" />
                                                  <property name="Output List.[05].Column" value="BirthDate" />
                                                  <property name="Output List.[05].DataType" value="DateTime" />
                                                  <property name="Output List.[06]" value="e.HireDate" />
                                                  <property name="Output List.[06].Table" value="e" />
                                                  <property name="Output List.[06].Column" value="HireDate" />
                                                  <property name="Output List.[06].DataType" value="DateTime" />
                                                  <property name="Output List.[07]" value="e.Address" />
                                                  <property name="Output List.[07].Table" value="e" />
                                                  <property name="Output List.[07].Column" value="Address" />
                                                  <property name="Output List.[07].DataType" value="String" />
                                                  <property name="Output List.[08]" value="e.City" />
                                                  <property name="Output List.[08].Table" value="e" />
                                                  <property name="Output List.[08].Column" value="City" />
                                                  <property name="Output List.[08].DataType" value="String" />
                                                  <property name="Output List.[09]" value="e.Region" />
                                                  <property name="Output List.[09].Table" value="e" />
                                                  <property name="Output List.[09].Column" value="Region" />
                                                  <property name="Output List.[09].DataType" value="String" />
                                                  <property name="Output List.[10]" value="e.PostalCode" />
                                                  <property name="Output List.[10].Table" value="e" />
                                                  <property name="Output List.[10].Column" value="PostalCode" />
                                                  <property name="Output List.[10].DataType" value="String" />
                                                  <property name="Output List.[11]" value="e.Country" />
                                                  <property name="Output List.[11].Table" value="e" />
                                                  <property name="Output List.[11].Column" value="Country" />
                                                  <property name="Output List.[11].DataType" value="String" />
                                                  <property name="Output List.[12]" value="e.HomePhone" />
                                                  <property name="Output List.[12].Table" value="e" />
                                                  <property name="Output List.[12].Column" value="HomePhone" />
                                                  <property name="Output List.[12].DataType" value="String" />
                                                  <property name="Output List.[13]" value="e.Extension" />
                                                  <property name="Output List.[13].Table" value="e" />
                                                  <property name="Output List.[13].Column" value="Extension" />
                                                  <property name="Output List.[13].DataType" value="String" />
                                                  <property name="Output List.[14]" value="e.Photo" />
                                                  <property name="Output List.[14].Table" value="e" />
                                                  <property name="Output List.[14].Column" value="Photo" />
                                                  <property name="Output List.[14].DataType" value="Byte[]" />
                                                  <property name="Output List.[15]" value="e.Notes" />
                                                  <property name="Output List.[15].Table" value="e" />
                                                  <property name="Output List.[15].Column" value="Notes" />
                                                  <property name="Output List.[15].DataType" value="String" />
                                                  <property name="Output List.[16]" value="e.ReportsTo" />
                                                  <property name="Output List.[16].Table" value="e" />
                                                  <property name="Output List.[16].Column" value="ReportsTo" />
                                                  <property name="Output List.[16].DataType" value="Int32" />
                                                  <property name="Output List.[17]" value="e.PhotoPath" />
                                                  <property name="Output List.[17].Table" value="e" />
                                                  <property name="Output List.[17].Column" value="PhotoPath" />
                                                  <property name="Output List.[17].DataType" value="String" />
                                                  <property name="Statistics.Open Count" value="1" />
                                                  <property name="Statistics.Row Count" value="9" />
                                                  <property name="Statistics.Average Row Count" value="9" />
                                                </properties>
                                                <input />
                                              </element>
                                            </input>
                                          </element>
                                        </input>
                                      </element>
                                      <element operator="ComputeScalar">
                                        <properties>
                                          <property name="Output List.[00]" value="e.EmployeeID" />
                                          <property name="Output List.[00].Table" value="e" />
                                          <property name="Output List.[00].Column" value="EmployeeID" />
                                          <property name="Output List.[00].DataType" value="Int32" />
                                          <property name="Output List.[01]" value="e.LastName" />
                                          <property name="Output List.[01].Table" value="e" />
                                          <property name="Output List.[01].Column" value="LastName" />
                                          <property name="Output List.[01].DataType" value="String" />
                                          <property name="Output List.[02]" value="e.FirstName" />
                                          <property name="Output List.[02].Table" value="e" />
                                          <property name="Output List.[02].Column" value="FirstName" />
                                          <property name="Output List.[02].DataType" value="String" />
                                          <property name="Output List.[03]" value="e.Title" />
                                          <property name="Output List.[03].Table" value="e" />
                                          <property name="Output List.[03].Column" value="Title" />
                                          <property name="Output List.[03].DataType" value="String" />
                                          <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                          <property name="Output List.[04].Table" value="e" />
                                          <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                          <property name="Output List.[04].DataType" value="String" />
                                          <property name="Output List.[05]" value="e.BirthDate" />
                                          <property name="Output List.[05].Table" value="e" />
                                          <property name="Output List.[05].Column" value="BirthDate" />
                                          <property name="Output List.[05].DataType" value="DateTime" />
                                          <property name="Output List.[06]" value="e.HireDate" />
                                          <property name="Output List.[06].Table" value="e" />
                                          <property name="Output List.[06].Column" value="HireDate" />
                                          <property name="Output List.[06].DataType" value="DateTime" />
                                          <property name="Output List.[07]" value="e.Address" />
                                          <property name="Output List.[07].Table" value="e" />
                                          <property name="Output List.[07].Column" value="Address" />
                                          <property name="Output List.[07].DataType" value="String" />
                                          <property name="Output List.[08]" value="e.City" />
                                          <property name="Output List.[08].Table" value="e" />
                                          <property name="Output List.[08].Column" value="City" />
                                          <property name="Output List.[08].DataType" value="String" />
                                          <property name="Output List.[09]" value="e.Region" />
                                          <property name="Output List.[09].Table" value="e" />
                                          <property name="Output List.[09].Column" value="Region" />
                                          <property name="Output List.[09].DataType" value="String" />
                                          <property name="Output List.[10]" value="e.PostalCode" />
                                          <property name="Output List.[10].Table" value="e" />
                                          <property name="Output List.[10].Column" value="PostalCode" />
                                          <property name="Output List.[10].DataType" value="String" />
                                          <property name="Output List.[11]" value="e.Country" />
                                          <property name="Output List.[11].Table" value="e" />
                                          <property name="Output List.[11].Column" value="Country" />
                                          <property name="Output List.[11].DataType" value="String" />
                                          <property name="Output List.[12]" value="e.HomePhone" />
                                          <property name="Output List.[12].Table" value="e" />
                                          <property name="Output List.[12].Column" value="HomePhone" />
                                          <property name="Output List.[12].DataType" value="String" />
                                          <property name="Output List.[13]" value="e.Extension" />
                                          <property name="Output List.[13].Table" value="e" />
                                          <property name="Output List.[13].Column" value="Extension" />
                                          <property name="Output List.[13].DataType" value="String" />
                                          <property name="Output List.[14]" value="e.Photo" />
                                          <property name="Output List.[14].Table" value="e" />
                                          <property name="Output List.[14].Column" value="Photo" />
                                          <property name="Output List.[14].DataType" value="Byte[]" />
                                          <property name="Output List.[15]" value="e.Notes" />
                                          <property name="Output List.[15].Table" value="e" />
                                          <property name="Output List.[15].Column" value="Notes" />
                                          <property name="Output List.[15].DataType" value="String" />
                                          <property name="Output List.[16]" value="e.ReportsTo" />
                                          <property name="Output List.[16].Table" value="e" />
                                          <property name="Output List.[16].Column" value="ReportsTo" />
                                          <property name="Output List.[16].DataType" value="Int32" />
                                          <property name="Output List.[17]" value="e.PhotoPath" />
                                          <property name="Output List.[17].Table" value="e" />
                                          <property name="Output List.[17].Column" value="PhotoPath" />
                                          <property name="Output List.[17].DataType" value="String" />
                                          <property name="Output List.[18]" value="Expr1121" />
                                          <property name="Output List.[18].Column" value="Expr1121" />
                                          <property name="Output List.[18].DataType" value="Int32" />
                                          <property name="Output List.[19]" value="Expr1122" />
                                          <property name="Output List.[19].Column" value="Expr1122" />
                                          <property name="Output List.[19].DataType" value="String" />
                                          <property name="Statistics.Open Count" value="46" />
                                          <property name="Statistics.Row Count" value="22" />
                                          <property name="Statistics.Average Row Count" value="0" />
                                          <property name="Defined Values.[0]" value="Expr1121 = Expr1080 + 1" />
                                          <property name="Defined Values.[0].Target" value="Expr1121" />
                                          <property name="Defined Values.[0].DataType" value="Int32" />
                                          <property name="Defined Values.[0].Source" value="Expr1080 + 1" />
                                          <property name="Defined Values.[1]" value="Expr1122 = Expr1081 + '.' + e.EmployeeID.ToString()" />
                                          <property name="Defined Values.[1].Target" value="Expr1122" />
                                          <property name="Defined Values.[1].DataType" value="String" />
                                          <property name="Defined Values.[1].Source" value="Expr1081 + '.' + e.EmployeeID.ToString()" />
                                        </properties>
                                        <input>
                                          <element operator="IndexSpool">
                                            <properties>
                                              <property name="Output List.[00]" value="e.EmployeeID" />
                                              <property name="Output List.[00].Table" value="e" />
                                              <property name="Output List.[00].Column" value="EmployeeID" />
                                              <property name="Output List.[00].DataType" value="Int32" />
                                              <property name="Output List.[01]" value="e.LastName" />
                                              <property name="Output List.[01].Table" value="e" />
                                              <property name="Output List.[01].Column" value="LastName" />
                                              <property name="Output List.[01].DataType" value="String" />
                                              <property name="Output List.[02]" value="e.FirstName" />
                                              <property name="Output List.[02].Table" value="e" />
                                              <property name="Output List.[02].Column" value="FirstName" />
                                              <property name="Output List.[02].DataType" value="String" />
                                              <property name="Output List.[03]" value="e.Title" />
                                              <property name="Output List.[03].Table" value="e" />
                                              <property name="Output List.[03].Column" value="Title" />
                                              <property name="Output List.[03].DataType" value="String" />
                                              <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                              <property name="Output List.[04].Table" value="e" />
                                              <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                              <property name="Output List.[04].DataType" value="String" />
                                              <property name="Output List.[05]" value="e.BirthDate" />
                                              <property name="Output List.[05].Table" value="e" />
                                              <property name="Output List.[05].Column" value="BirthDate" />
                                              <property name="Output List.[05].DataType" value="DateTime" />
                                              <property name="Output List.[06]" value="e.HireDate" />
                                              <property name="Output List.[06].Table" value="e" />
                                              <property name="Output List.[06].Column" value="HireDate" />
                                              <property name="Output List.[06].DataType" value="DateTime" />
                                              <property name="Output List.[07]" value="e.Address" />
                                              <property name="Output List.[07].Table" value="e" />
                                              <property name="Output List.[07].Column" value="Address" />
                                              <property name="Output List.[07].DataType" value="String" />
                                              <property name="Output List.[08]" value="e.City" />
                                              <property name="Output List.[08].Table" value="e" />
                                              <property name="Output List.[08].Column" value="City" />
                                              <property name="Output List.[08].DataType" value="String" />
                                              <property name="Output List.[09]" value="e.Region" />
                                              <property name="Output List.[09].Table" value="e" />
                                              <property name="Output List.[09].Column" value="Region" />
                                              <property name="Output List.[09].DataType" value="String" />
                                              <property name="Output List.[10]" value="e.PostalCode" />
                                              <property name="Output List.[10].Table" value="e" />
                                              <property name="Output List.[10].Column" value="PostalCode" />
                                              <property name="Output List.[10].DataType" value="String" />
                                              <property name="Output List.[11]" value="e.Country" />
                                              <property name="Output List.[11].Table" value="e" />
                                              <property name="Output List.[11].Column" value="Country" />
                                              <property name="Output List.[11].DataType" value="String" />
                                              <property name="Output List.[12]" value="e.HomePhone" />
                                              <property name="Output List.[12].Table" value="e" />
                                              <property name="Output List.[12].Column" value="HomePhone" />
                                              <property name="Output List.[12].DataType" value="String" />
                                              <property name="Output List.[13]" value="e.Extension" />
                                              <property name="Output List.[13].Table" value="e" />
                                              <property name="Output List.[13].Column" value="Extension" />
                                              <property name="Output List.[13].DataType" value="String" />
                                              <property name="Output List.[14]" value="e.Photo" />
                                              <property name="Output List.[14].Table" value="e" />
                                              <property name="Output List.[14].Column" value="Photo" />
                                              <property name="Output List.[14].DataType" value="Byte[]" />
                                              <property name="Output List.[15]" value="e.Notes" />
                                              <property name="Output List.[15].Table" value="e" />
                                              <property name="Output List.[15].Column" value="Notes" />
                                              <property name="Output List.[15].DataType" value="String" />
                                              <property name="Output List.[16]" value="e.ReportsTo" />
                                              <property name="Output List.[16].Table" value="e" />
                                              <property name="Output List.[16].Column" value="ReportsTo" />
                                              <property name="Output List.[16].DataType" value="Int32" />
                                              <property name="Output List.[17]" value="e.PhotoPath" />
                                              <property name="Output List.[17].Table" value="e" />
                                              <property name="Output List.[17].Column" value="PhotoPath" />
                                              <property name="Output List.[17].DataType" value="String" />
                                              <property name="Statistics.Open Count" value="46" />
                                              <property name="Statistics.Row Count" value="22" />
                                              <property name="Statistics.Average Row Count" value="0" />
                                              <property name="Logical Operator" value="Eager Spool" />
                                              <property name="With Stack" value="False" />
                                              <property name="Index" value="e.ReportsTo" />
                                              <property name="Index.Table" value="e" />
                                              <property name="Index.Column" value="ReportsTo" />
                                              <property name="Index.DataType" value="Int32" />
                                              <property name="Probe" value="Expr1062" />
                                            </properties>
                                            <input>
                                              <element operator="TableScan">
                                                <properties>
                                                  <property name="Table" value="Employees AS e" />
                                                  <property name="Output List.[00]" value="e.EmployeeID" />
                                                  <property name="Output List.[00].Table" value="e" />
                                                  <property name="Output List.[00].Column" value="EmployeeID" />
                                                  <property name="Output List.[00].DataType" value="Int32" />
                                                  <property name="Output List.[01]" value="e.LastName" />
                                                  <property name="Output List.[01].Table" value="e" />
                                                  <property name="Output List.[01].Column" value="LastName" />
                                                  <property name="Output List.[01].DataType" value="String" />
                                                  <property name="Output List.[02]" value="e.FirstName" />
                                                  <property name="Output List.[02].Table" value="e" />
                                                  <property name="Output List.[02].Column" value="FirstName" />
                                                  <property name="Output List.[02].DataType" value="String" />
                                                  <property name="Output List.[03]" value="e.Title" />
                                                  <property name="Output List.[03].Table" value="e" />
                                                  <property name="Output List.[03].Column" value="Title" />
                                                  <property name="Output List.[03].DataType" value="String" />
                                                  <property name="Output List.[04]" value="e.TitleOfCourtesy" />
                                                  <property name="Output List.[04].Table" value="e" />
                                                  <property name="Output List.[04].Column" value="TitleOfCourtesy" />
                                                  <property name="Output List.[04].DataType" value="String" />
                                                  <property name="Output List.[05]" value="e.BirthDate" />
                                                  <property name="Output List.[05].Table" value="e" />
                                                  <property name="Output List.[05].Column" value="BirthDate" />
                                                  <property name="Output List.[05].DataType" value="DateTime" />
                                                  <property name="Output List.[06]" value="e.HireDate" />
                                                  <property name="Output List.[06].Table" value="e" />
                                                  <property name="Output List.[06].Column" value="HireDate" />
                                                  <property name="Output List.[06].DataType" value="DateTime" />
                                                  <property name="Output List.[07]" value="e.Address" />
                                                  <property name="Output List.[07].Table" value="e" />
                                                  <property name="Output List.[07].Column" value="Address" />
                                                  <property name="Output List.[07].DataType" value="String" />
                                                  <property name="Output List.[08]" value="e.City" />
                                                  <property name="Output List.[08].Table" value="e" />
                                                  <property name="Output List.[08].Column" value="City" />
                                                  <property name="Output List.[08].DataType" value="String" />
                                                  <property name="Output List.[09]" value="e.Region" />
                                                  <property name="Output List.[09].Table" value="e" />
                                                  <property name="Output List.[09].Column" value="Region" />
                                                  <property name="Output List.[09].DataType" value="String" />
                                                  <property name="Output List.[10]" value="e.PostalCode" />
                                                  <property name="Output List.[10].Table" value="e" />
                                                  <property name="Output List.[10].Column" value="PostalCode" />
                                                  <property name="Output List.[10].DataType" value="String" />
                                                  <property name="Output List.[11]" value="e.Country" />
                                                  <property name="Output List.[11].Table" value="e" />
                                                  <property name="Output List.[11].Column" value="Country" />
                                                  <property name="Output List.[11].DataType" value="String" />
                                                  <property name="Output List.[12]" value="e.HomePhone" />
                                                  <property name="Output List.[12].Table" value="e" />
                                                  <property name="Output List.[12].Column" value="HomePhone" />
                                                  <property name="Output List.[12].DataType" value="String" />
                                                  <property name="Output List.[13]" value="e.Extension" />
                                                  <property name="Output List.[13].Table" value="e" />
                                                  <property name="Output List.[13].Column" value="Extension" />
                                                  <property name="Output List.[13].DataType" value="String" />
                                                  <property name="Output List.[14]" value="e.Photo" />
                                                  <property name="Output List.[14].Table" value="e" />
                                                  <property name="Output List.[14].Column" value="Photo" />
                                                  <property name="Output List.[14].DataType" value="Byte[]" />
                                                  <property name="Output List.[15]" value="e.Notes" />
                                                  <property name="Output List.[15].Table" value="e" />
                                                  <property name="Output List.[15].Column" value="Notes" />
                                                  <property name="Output List.[15].DataType" value="String" />
                                                  <property name="Output List.[16]" value="e.ReportsTo" />
                                                  <property name="Output List.[16].Table" value="e" />
                                                  <property name="Output List.[16].Column" value="ReportsTo" />
                                                  <property name="Output List.[16].DataType" value="Int32" />
                                                  <property name="Output List.[17]" value="e.PhotoPath" />
                                                  <property name="Output List.[17].Table" value="e" />
                                                  <property name="Output List.[17].Column" value="PhotoPath" />
                                                  <property name="Output List.[17].DataType" value="String" />
                                                  <property name="Statistics.Open Count" value="1" />
                                                  <property name="Statistics.Row Count" value="9" />
                                                  <property name="Statistics.Average Row Count" value="9" />
                                                </properties>
                                                <input />
                                              </element>
                                            </input>
                                          </element>
                                        </input>
                                      </element>
                                    </input>
                                  </element>
                                </input>
                              </element>
                            </input>
                          </element>
                        </input>
                      </element>
                    </input>
                  </element>
                </input>
              </element>
            </input>
          </element>
        </input>
      </element>
    </executionPlan>
  </expectedPlan>
</test>